Combo Box refresh

[nberryman]

I am having problems getting a combo box to refresh when I change records.

The combo box gets the data from a table via criteria in a field on the form. It pick up the criteria data when I open the form but when I change records it maintaing list for the first question.

Where am I going wrong!!!!!!!!!!!!!!!!!!



Neil Berryman
IT Trainer
neil_berryman@btopenworld.com

 

[LittleSmudge]

Are you saying your combo's RowSource is something like:-

"SELECT flied1, field2 FORM tblName WHERE field3 = '" & controlOnForm & "'"


Then the problem could stem from having the combo box itself higher up the tab order than the controlONForm that provides the criteria for the RowSource.

Solution.
In the Form's On_Current event put
ComboControlName.Requery

( Or change the tab order sequence. )


'ope-that-'elps.

G LS

 

[nberryman]

Thanks, all is now well the

On_Current event


ComboControlName.Requery

worked a treat

Thanks
Neil Berryman
IT Trainer
neil_berryman@btopenworld.com