[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Access 2010 auto-fill issues

Posted on 2013-06-19
2
Medium Priority
?
566 Views
Last Modified: 2013-06-19
I have a DB with a SQL backend. There are three tables linked. I'm trying to use a barcode scanner to enter info quickly into a form. When I scan the Work Order number I'd like the description, date entered, due date all auto-filled. I was trying Dlookup but didn't have any luck.

Is Dlookup my best choice here? Or are there other ways to go about this?

Thanks

Chris
0
Comment
Question by:Worth_and_Co
2 Comments
 
LVL 35

Accepted Solution

by:
Norie earned 200 total points
ID: 39259943
Chris

How were you using DLookup and what problems did you have with it?
0
 

Author Closing Comment

by:Worth_and_Co
ID: 39260011
I was able to figure it out, I was trying to use it in VBA, not realizing you could use expression builder. Once I did, I ran right through it, not issue. Thank you for answering so quickly.

Chris
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question