Multiple unbound controls

[slimjen]

Hi all, I'm using access 2016...I have a form with 2 unbound controls. The users are able to select from the 1st cbo and it filters the 2nd cbo..when users select from the 2nd cbo..the related data on the form appears....it works as expected..My problem is when the user changes the selection from the 1st drop down, the 2nd cbo requeries and is blank...which I want but the data from the first selection remains until the user makes a new selection..how can when the 2nd selection requeries and is blank the data resets/blank? There's too many fields to list n the code to = "" can someone give me another way around this please.. I hope I've explained enough to help you help me..thank you

[ranman256]

the 2nd combo SHOULD be blank, since you cant know what the user is going to pick for the 1st combo, thus rendering 2nd combo invalid.
and should be blank.

[slimjen]

Thanks for replying...yes, it does and works like I expected...but when the user selects another from the 1st cbo, the data on the form remains before the selection from the 2nd cbo...when the 2nd cbo is blank...users are getting confused if they walk away and return stating they don't know which cust. The data belongs to...trying to prevent this...

[Gicu]

Add a Me.Requery in the AfterUpdate event of combo1 (after you set Me.combo2=Null).

Cheers,
Vlad