multi field lookup (1 Viewer)

jmills

New member
Local time
Today, 07:58
Joined
Jun 13, 2019
Messages
7
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

Super Moderator
Staff member
Local time
Tomorrow, 01:58
Joined
Jan 20, 2009
Messages
12,849
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

I’m here to help
Staff member
Local time
Today, 07:58
Joined
Oct 29, 2018
Messages
21,358
Hi. One solution is to overlay a Textbox on top of the Combobox bound to the same field.
 

Users who are viewing this thread

Top Bottom