Price Lookup

[Rick Brown]

Hi. I'm in need of some help. I'd like to create a Price Lookup form for a
Microsoft Retail Management software client. The computer would be just for
customer price lookups. I have Access linked to the SQLServer db via ODBC
and have the tables available. The fields are ItemLookupCode, Description
and Price. A customer would come up to the computer and scan an item's
barcode into the ItemLookupCode field and it would retrieve the Description
and Price. That record would sit there until another Barcode is scanned into
the ItemLookupCode field and it would return the Description and Price for
that item, and so on, performing the same function over and over. I don't
know how to make it do the lookup each time a barcode is scanned into the
field. Thanks, Rick.

 

[Rick Brown]

Would it help if I said that scanning a barcode is the same as typing a 12
digit number and hitting enter?

Rick

 

[B. Comrie]

You can use DLookup

Dim strDisplay as string
strDisplay = DLookup("Description","TheTableName","ItemLookupCode=" &
TheScannedCode")
strDisplay = strDisplay & " " &
DLookup("Price","TheTableName","ItemLookupCode=" & TheScannedCode")
'Code To display Goes here.....

B Comrie
http://www.codewidgets.com