Combo Box HELP!!

[Guest]

I am creating a database that allows users to perform an account lookup. The
user will enter an account number and peform a search, if the account
matches, the db brings back the number of times the account appears on the
table. It also populates the account number on a sub-form for entry. The
purpose of the db is to add and track repeat offenders. My question is, if
the account is not listed, how do I populate it on the subform so the user
does not have to re enter the data? I am currently using a combo box to
perform the lookup and a subform to enter the data.

Thanks

 

[George Nicholson]

The ComboBox has a NotInList event that you can program to handle new
entries.

http://support.microsoft.com/kb/197526/
Use NotInList Event to Add a Record to Combo Box


HTH