combo box

[Nathan]

i have a combo box on my form which i use to find records.
however when i search through the records with the normal
navigation buttons the data in the combo box does not
change. is there anyway i can set the combo box so that
the data in it does change and display the info for that
record?

 

[Lee]

Hi,
Have you tried requerying the combo box on the 'after
update' event of the form? For example,

Private Sub Form_AfterUpdate()

Me!NameOfComboBox.Requery

End Sub

HTH

Lee