Combo box and navigation buttons

mkelly

Registered User.
Local time
Today, 02:05
Joined
Apr 10, 2002
Messages
213
If I use a combo box to look up a record on a form. Is there anyway to link the navigation buttons to that combo box so that when the records are scrolled the look up combo box info matches the displayed record?
 
You can't bind the combobox, or selecting another value to search for would change the current record. So the only other method would be to handle it manually. Have you concidered just using a second one bound to the underlaying table/query field instead.
 
I may have mis-read what you want, but why not use the Form's On current event to tie the combobox to any changes in the bound field on the form. Example, if Combo01 is used to select an unbound record (in an AfterUpdate Event etc), put this in the On_Current Event for the form:

Combo01 = Me.BoundFieldTextbox

If you then scroll through the navigation buttons, the combobox automatically changes to match.
 

Users who are viewing this thread

Back
Top Bottom