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.
Thanks!
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.
Thanks!