Update combo box as you move between records

[scheeps]

I've got a combo box in my form header which has been created by the "Find a record on my form based on the value I selected in my combo box". The combo box works fine for record selection, but if I navigate between records the Combo stays static and does not update as you move between records.

Is there a way to update the combo box in my header to whichever record I navigate to?

 

[pbaldy]

That happens because the combo is not bound to the underlying data (nor should it be). Rather than trying to keep it displaying the current record, I typically set it to Null or a zero length string after a selection so it is blank to the user.

 

[scheeps]

Thanks Paul, I thought that would be my second option.

On which event should I reset my combo to null/empty string when moving between records?

 

[pbaldy]

I'd do it in the same code that finds a record (typically the after update event of the combo). If you wanted to keep it in sync or clear it when you changed records, you'd do it in the current event. To me, that confuses the issue, but that's personal preference.