Search for ALL records in a form


New Member
Apr 18, 2019
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":

Company NameNDT


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!

Forum statistics

Latest member

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...