JimbobGilb
Posts: 28
|
Posted: 11/11/2011, 8:23 AM |
|
Struggling on maybe something simple.
If CCDLookup("PartNumber", "PartMaster", "PartNumber='"&PickedItems.PartNumber.value&"'", DBConnection1) <> PickedItems.PartNumber.value Then
PickedItems.Errors.addError("PART NUMBERS Do Not match.")
this works great but i need to add a WHERE statement to select a unique record, where a form field PickedItems.TextBox1.Value = The ID field in the access database table but cannot get this to work.
Any ideas would be most appreciated.
|
|
|
|