Datasheet View: Second Combo Box Criteria Based on First Combo Box Value

[Rosalie Tackett]

Hello,

I need a query that will determine the values in a dropdown box (Module),
based on the value chosen in another dropdown box (Dir).

SELECT Modules.Module FROM Modules WHERE Modules.Directory=Dir.Value;

Tried:
Dir
[Dir]
[Dir].Value
Me.Dir
Me.Dir.ListBox
etc.

I'm sure others must have successfully accomplished this. Many thanks if
you can help me!!! Otherwise, I'm giving up.

Rosalie Tackett