One Combo Box affecting the next Combo Box

[rconnel1]

Folks,

I have a table which I use to track all the equipment and subsections of the equipment in our factory. Column1 is EntryID (Primary Key). Column2 is the machine name. Column3 is the subsection of the particular machine in Column2. There is 30 different machines and each machine might have 20 different subsections. 600 line table. Call this tbl_Master_list

I have a separate table which I intend to use to track all faults on machines in the plant. To aid the entry of this information by maintenance staff I was trying to help with the data entry as follows.

Step 1 - Maintenance staff are selecting the Machine, this is coming out of tbl_Master_list. The combo box should only show the list of machines and not the 600 entries in the list, ie there are repetitions because of each subsection. I want them to see the list of machines.

Step 2 - Once Step 1 is done I want the next combo box to only show the subsections of the machine selected in Step 1.

Any help.

New to Access

 

[freakazeud]

Hi,
this is called cascading comboboxes. Search the forums as there should have been many discussions on this.
You can use a distinct query to populate your first combobox to get distinct values and then use the cascading comboboxes method to filter down the selections.
You can also look here if you want: http://office.microsoft.com/en-us/assistance/HA011730581033.aspx
HTH
Good luck