im trying to create a job costing database for my job. my boss is looking to be able to pull information from a table containing a work order number employee employee id number and job duration, and place it into a report. however hes looking to be able to type the work order number into the first text box of the report and have it auto-fill the rest of the information automatically. i was able to figure out how to do this in a form using DLookUp, but havent gotten it to work yet in the form. would appreciate any help i can get.
thanks!
thanks!