Lookup field in Access form doesn't "hold" the results

J

JDJones

I have a form with two lookups that lookup values based on another lookup.
That part is working fine. However, the two fields don't "hold" the results
(or display them) after I move to another records If I go back to the record
just completed, nothing shows. But the underlying query is holding the
results. It's set to "show always", moved to the front, and bound to an
underlying query field. I don't see anything that could be causing it to not
show.
 
T

tina

i'm guessing that you have code set on the first combo box control's
AfterUpdate event, to requery the dependent comb boxes. when you use
"cascading" combo box controls in a form, you also have to set code on the
form's Current event to requery the dependent combo box controls as you move
from record to record.

hth
 
Top