I have two tables, one is "inventory" and the
other is "sale". I created form using the fields from "sale". in the
"inventory" table, I saved barcodes of all items.
Here, I want the
form to populate the "item" name and "price" of the barcode I enter in
the barcode textbox of the form. Currenty, it shows only the first
record of the item and price, but I want the item name and price of the every unique barcode I enter in the barcode control of the form. The "inventory" table contains all barcodes of all the items in store and their "item" name and "price" field. but, dlookup not looking up the whole field. its showing only the first record.
in the barcode textbox after-update, I typed the dlookup as follows:
item = dlookup("item", "inventory")
Price = dlookup("price", "inventory")
Hope any angel's gonna help me ^_^ ... thanks in advance.