How to prevent wrong data to be enterd in a form on access

G

Guest

In my data base, I have a table called "partmaster". This table cotaines a
field called part number, this table is my master part number data base.
I also have another table in the same data base, that contains all the
parts that have been imported to US at different time intervals. This table
also have a field called part number.
This table is called import.
What I want is at the time of entering data in to the import table using the
form, the system to flg if the part number that is entered is not in my
partmaster table.
Can I use setfocus.
thanks
 
A

Al Campagna

Steve,
Use a combobox where the RowSource is a query based on the legitimate PartNos from yor
table. Set the LimitToList for the combo to Yes.
Users will not be able to enter a PartNo that does not exist in your PartNo table.

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 

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

data validation in form during data entry 1
Form for Parts-Tools Lists 0
Prevent Duplicate Form Entries 0
Access Updating inventory levels 0
Filling in fields to a partially complete record in a table using a form 0
Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0
Using DSUM to get running total on a filtered form 0
VBA - retrieve data on last create named range from previous inserted named range 0

Top