Looking Up Address Info From Another Table

T

thedroz

Hi All!

In my Activity database I have two tables: DailyAct and Addresses. I have
created a form where the Name/Place is a Combo Box where the Row Source Type
is set for the Addresses Database.

Once the user selects from the Combo Box, I would like the House Number and
Street Name to auto populate on the form. I created a Query, but I run into
a problem when they try to enter an address that is not in the Addresses
database.

The users will need to enter some addresses that are not in the Addresses
database. Can this be done?

Thanks in advance1
 
L

Larry Daugherty

Look in Hellp for the NotInList event. I believe that they give an
example.

HTH
 
Top