data validation in form during data entry

[Guest]

I have two tables that have a common field called part number.
One of these tables are my master part number listing and it is called
"partmaster".
The other table contains the list of parts that are imported to US. This
table is updated on a weekly basis. This table is called "import".
Currently when I enter data to the import table using import form, the
system will accept any data entred at the part number field and I do not know
if I have entered a correct part number or not?
Is there any way that during data entry to import table, the field called
part number to look at the part master table and flg if the part number
entered into import form is not in the partmaster table.

 

[Damon Heron]

For the part number, use a combobox rather than a textbox. There is a
wizard that will guide you through the set up process. If you don't use the
wizard, set the rowsource of the combobox by clicking on the (...) to the
right of the rowsource property, and create a query based on the partmaster
table. The controlsource of the combobox should be the partnumber.

HTH
Damon