multi field lookup
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