Corresponding one field to another

[shaz123]

Hi,
I have got an input box, were production scans a the barcode no, the information is then recorded into another table. What i need to do is pick up the cylinder serial number matching to the barcode number scanned.

Both the fields are originaly within one table, would i need to use an sql statement?

 

[PHV]

Perhaps the DLookUp function ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886