Find a number in another table and change condition in original

[socasteel21 via AccessMonster.com]

I have a database that is used extensively to log warranty claims. There are
2 forms that this problem concerns, a warranty claim form and a warranty
registration form. Each of these forms is based off of a different table.

I would like to be able to enter a machine serial number on the claim form
and have a checkbox that would be checked if the machine serial number exists
in the Warranty Registration table, and unchecked if it does not.

I also have a button that opens the warranty registration form from the claim
form, and I would like the button to take me to the record in the warranty
registration form that cooresponds to the serial number entered on the claim
form.

Any help would be appreciated.

Thanks,
Shannan

--
Message posted via http://www.accessmonster.com