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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!