• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 568
  • Last Modified:

Access 2010 auto-fill issues

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
Worth_and_Co
Asked:
Worth_and_Co
1 Solution
 
NorieVBA ExpertCommented:
Chris

How were you using DLookup and what problems did you have with it?
0
 
Worth_and_CoAuthor Commented:
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

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now