Search for ALL records in a form

iamtrangdoan

New Member
Joined
Apr 18, 2019
Messages
1
Hi everyone,

I've been looking all over the internet to get my form displayed all records when a selection is made from a Combo Box, however, I haven't found the solution.

Below is the table "tblCap_NDT" which I used to create form "frmCap_NDT":

[TABLE="class: cms_table_grid, width: 500, align: center"]
<tbody>[TR]
[TD="align: center"]Company Name[/TD]
[TD="align: center"]NDT[/TD]
[/TR]
[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]Radiographic[/TD]
[/TR]
[TR]
[TD="align: center"]B[/TD]
[TD="align: center"]FPI[/TD]
[/TR]
[TR]
[TD="align: center"]B[/TD]
[TD="align: center"]Radiographic[/TD]
[/TR]
[TR]
[TD="align: center"]D[/TD]
[TD="align: center"]Ultrasonic[/TD]
[/TR]
[TR]
[TD="align: center"]D[/TD]
[TD="align: center"]Radiographic[/TD]
[/TR]
[TR]
[TD="align: center"]D[/TD]
[TD="align: center"]FPI[/TD]
[/TR]
[TR]
[TD="align: center"]D[/TD]
[TD="align: center"]MPI[/TD]
[/TR]
[TR]
[TD="align: center"]E[/TD]
[TD="align: center"]MPI[/TD]
[/TR]
[TR]
[TD="align: center"]E[/TD]
[TD="align: center"]FPI[/TD]
[/TR]
[TR]
[TD="align: center"]E[/TD]
[TD="align: center"]Radiographic[/TD]
[/TR]
[TR]
[TD="align: center"]F[/TD]
[TD="align: center"]Radiographic[/TD]
[/TR]
</tbody>[/TABLE]


I created a Combo Box in the form header from the "NDT" column and set it to display only unique values. Then I dropped the "Company Name" field to the Detail section of the form. However, the combo box didn't seem to be able to search for all records, rather it couldn't search for anything at all.

My aim is search for all Company Names when a NDT value from the Combo Box is selected.

For example, if FPI was selected, the result would count and return B, D, and E (Like 1.B 2.D 3.E)

I tried to create a subform in the Detail section as well but that didn't work. It seemed to return the first value correctly, however, the rest of the results were all the same as the first. For example, when I selected Ultrasonic, instead of getting only D, I got 4 Ds which I assumed to be all the D left in the table (and certainly they didn't match with the search key "Ultrasonic").

Can anyone shed me some light on this please? This is driving me crazy since I have no experience in programming or Access. Thank you very much in advance!
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top