DLookup Issues

[Dave14867]

Ok Folks,

I am sure this will be quicker to answer than it was to type this out. I am new to the DLookUp function and can't get it to work correctly ( in fact-doesn't work at all).

I am trying to populate a txt field upon a form loading with VBA using the following statement.

Me.TxtOrgName = DLookup("OrgName", "tblSettings", "TxtOrgName='string'")

What am I missing, I haven't used DLookup before so I am sure it is something simple I'm missing.



Thanks

Dave

[June7]

You have OrgName value of "string"? The DLookup is looking for literal text "string". Why do you even need to save organization's name to this table? What is database structure? If you want to provide db for analysis, follow instructions at bottom of my post.

[Dave14867]

June7,

I hope to be able to put this out to other users and the settings table allows others to be able to put in their own unique data.

I did get this working by putting the DLookUp function in the "Control Source" in the properties and fixing the format and requirement of the string.

Thanks

Dave