Combo Lookup problem

[Guest]

I have created a form that lists members information, I have added a combo
box that is used as a 'search' facility. This works fine and when I select a
members name then their relevant information is shown. However if the user
then decides to abandon the search facility and browse the records via the
stand previous and next records button then the name currently in the combo
box remains the same and choose not change when the record does.

Is there a way of making sure it changes. I know there probably is a simple
answer to this but I cant seem to find it.

 

[Allen Browne]

You can keep the combo up to date if you use the Current event of the form,
and also the AfterUpdate event of the control.

However, the simplest solution is to clear the combo after the record is
found, e.g.:
Me.Combo1 = Null

 

[Guest]

I am having the exact same problem (ie the value in my combo box selector
does not update if the next or previous record selection buttons on the form
are used instead of selecting a value from the combo box) but your answer is
too vague for me. Where to I put this "me.Combo1 = Null" DO i put it
somewhere in the AfterUpdate event code? If you could please give a more
detailed explanation of how to get the combo box to update when the record
selector buttons are used I would be very appreciative. Thanks