Comparing field data in VB (access)
Hi.
To set the scene:
The user enters an order number, followed by a list of serial numbers for machines (called MDW's)
so for example:
Order: 846845
Serial:
2156
2468
2374
In another form the user has to enter the serial number and then enters details about that product, such as description, version etc.
When the user enters a number into the second bit (where they add a description, and version) i want it to compare to the Order section. To see if that serial number is actually valid.
Hope that makes sense.....:rolleyes:
I have been trying to use dlookup to make it compare the fields, but this doesnt seem to be working.
Can anyone help me make a bit of code to compare the two fields?
I would be very grateful.
Thanks
Will