multi field lookup

[jmills]

I have a continuous form sub-form embedded on multi-table data entry form. The sub-form has 3 fields. The first is a look up field that gets its list from a query that works fine. The second lookup field needs to get its list from a query with a criteria based on field 1. My query works for the first record in the sub-form. However for all the subsequent records, field 2 only shows the lookup list associated with field 1 in record 1. Any idea how I can get the criteria for the second query to reset after each new field 1 is populated?

Thanks for your help

JRM

 

[Galaxiom]

Sounds like it is a classic Cascading Combo structure.

You would need to requery the combo on the Current Event to change its Row Source.

 

[theDBguy]

Hi. One solution is to overlay a Textbox on top of the Combobox bound to the same field.

 

[CJ_London]

if you are talking about cascading combo's in a continuous form then you might find this link helpful

https://www.access-programmers.co.uk/forums/showthread.php?t=275155