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