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.....

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