Form Problem

Joined
Sep 14, 2010
Messages
2
Reaction score
0
I am trying to create a form field that will look up to see if the value you type in the field already exists in the table.

Example: Enter a Zip Code into the field on the form. If the Zip exists in the underlying table, show the record in sub form to the right.

If the Zip does not exist, then I want to have the form move me into the sub form and allow me to enter the new Zip to the table. Then move me into the next field on the main form.

If the Zip already exists, I do not want to go into the sub form, just move into the next field on the main form.

Should I use a macro on the ON EXIT event to do this?

How in 2010 is this best created?

Any help you would be really appreciated.
 

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

Form Problem 0
Access Form Refresh 1
Dlookup Syntax Help 3
Prevent Duplicate Form Entries 0
How to accomplish this ? 3
Access Daily Entry with multiple entries per field 0
Data entry to table from a form 1
Form is filtering out values 2

Top