Sync combo box with new records

S

StrayCat

I lost the book that told me how to do this simple code.
Suppose the combo box is linked to show customer's names
via the key field customerID. The combo box works fine
except when the user starts moving to new records via the
navigation buttons. When they do this how can I get the
name in the combo box to change as well so that it
remains in sync with whatever name is showing on the form?
 
G

Graham Mandeno

In the Form_Current event procedure, put the line:

Me.[Combo box name] = Me.CustomerID
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top