I have designed a data base for excess inventory. This data base file consists of several tables; one of these tables contains part number, price and specification, and other pertained information regarding the part identification. This file is called "MATERIAL DATA BASE" and part number is the primary field in this table. This table is my permanent data base file and I use this table to retrieve pertinent information about the part number. I have another table called "PART UTILIZATION" that shows part number, quantity and date that parts have been used. There is no primary field in this table. Currently I enter data in to "PART UTILIZATION FORM" and perform query to retrieve pertinent information about the part number. After the query is done I have to check and see if all the part numbers that I have entered in "PART UTILIZATION FORM" are in the query list. Problem is if I make a mistake and miss type a part number I will not know about this data entry error till the query is done. I was wondering if there is a code or expression that I could put in my "PART UTILIZATION FORM" to validate part number that I enter in to this form against the "MATEIAL DATA BASE" table instantly and provide immediate feed back prior to execution of full query. Currently I have an intermediate step for validation prior to query execution, this is very time consuming. I am looking for a short cut. ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, visit the group's homepage and use the dropdown menu at the top. This will allow you to unsubscribe your email address or change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso If you are using Outlook and you see a lot of unnecessary code in your email messages, read these instructions that explain why and how to fix it: http://personal-computer-tutor.com/abc3/v28/greg28.htm *************************************************************