Help with lookup drop down.

[Scott]

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

 

[Ken Snell \(MVP\)]

See this article:
http://www.mvps.org/access/forms/frm0028.htm

You can do it in a form, but not in a table.

 

[Scott]

Thanks for the reply. Man, that looks very complicated.

 

[Ken Snell \(MVP\)]

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.