I have a slight problem understanding the DLookup Method (I think it's a method :P)
I am not completely new to programming but I am self-taught so... couple of things lacking in my head.
I have 2 tables, 1st : Product table, 2nd Cost of those products
Both tables have SKU fields
In the Cost table whenever the user adds a new record (which must contain a SKU) the said SKU must be a valid SKU in the Product table.
I THINK I must use the :
Private Sub SKU_LostFocus()
Then use the dlookup to check if the SKU exists in the SKU field of the product_table
But I am unsure.
Help would be really appreciated. I have tried to read the Dlookup method on Microsoft's website without any result
And sorry for my english
Feel free to ask questions I'll try to answer as fast as possible.