Looking Up Address Info From Another Table

G

Guest

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
 

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

Similar Threads

Combo Box Problems 2
Please offer your thoughts on the best way to set this up . . . 3
Result of one combo box, affecting results of another... 8
Query filtering in Access 2007 not the same as 2003? 1
contact address and/or billing address 4
how to select from a table and fill in other data in access 3
Mail-Merge, Word, Access, and Address Labels 2
Address parsing algorithm needed please 9

Top