Dlookup Cheat in a Default Table - DLookup in Microsoft Access


	Back to DLookup Comments List

Dlookup Cheat in a Default Table

Erik Emerson

5 hours ago

Likely someone has thought about this before…
If you are using Dlookup to find a value from a Default Table and “double double” for text a is not your thing, set up the Default Table Fields like this: Default_ID(autonumber), Default_Value (Text), Default_Title (Text).
Set the Dlookup to point to the Default Table and have access search for the Default_ID number and pull the Default_Value.

Access is picky when using Dlookup. Access is less picky about how you format a table or form. If you need to text to explain the Default_Value, which is a good idea, build a Default Entry Form and put the Default_Title field before the Default_Value.

Richard Rost @Reply

4 hours ago

Yep, that's a perfectly good approach. Using a numeric primary key makes the DLookup criteria much simpler and avoids having to worry about quoting text values.

The Default_Title field also gives you a nice human-readable description of what each setting is for, while Default_Value holds the actual value you want to retrieve.

I always try to keep my DLookups numeric if possible, but every now and then you've got to find something based on an email address or other text value, so you've got to learn that double-double-quote stuff.

	Erik Emerson OP @Reply 4 hours ago
I understand—we need to learn how to use “double double” quotes. With more time and patience, I’d get better at them, but who has enough of either? As always, thank you for your content and your time.

	Richard Rost @Reply 3 hours ago
Oh, I know it's all about time. Trust me, there's lots of stuff that I want to do, just not enough hours in the day. We do what little we can, try to do a little bit every day, and slowly get better. That's how progress is made. Rome wasn't built in a day.

Next Unseen