Using Access VBA to check if the record exists in the table

[thanosgr]

Hi
Ive got a form with subform

Main form consist of

ProjectId
Supplier
Supervisor
Date

and in the subform
Contains
ProductNumber,Product Description, Stock, Price, Final Price.


Now the form and subform works as insert

What i want is to check if the productnumber exists, then the productdecription filled, and i insert values to stock, price, etc.
If not, then we add a new product.

I figure out with Recordsets. but where should i put the vba code?
on Form Load?
using after update into the product id?

what is the best way to do it?



Thanks

PS any help with dummy code will be appreciate also

[June7]

You could use a combobox with LimitToList Yes then users can only select a valid product number.

Otherwise, a simple DLookup could verify if the item exists. However, if you want to move to the record if it exists, need to use RecordsetClone and Bookmarks or set Filter properties.