Help with lookup drop down.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am not sure if it is possible, but I would like to create a datasheet and
form where I can have a drop down (lookup) for a field and then have the next
field have a drop down (lookup) based on the selection of the first field.
For Example:

If in field 1 I have a list of manufacturing lines Modules 1, 2, 3, 4 then
on field 2 I would like to have a list of machine numbers based on the module
selected in the first field. So, if Module 2 is selected then field 2's drop
list would list the machine numbers for Module 2. Can this be done? Is there
a way to create a condition for calling up a table or datasheet?

Thanks,

Scott
 
Not really. The concept is to have a WHERE clause in the "child" combo box's
RowSource query that uses the value from the "parent" combo box, and then to
requery the "child" combo box in the AfterUpdate event of the "parent" combo
box.
 
Back
Top