I have created a combo box that pulls the "Vendor Number" from the "Vendor List" table. The "Vendor Number" is stored in the "Vendor ID" on my "Budget" form. I want to use the DLookup to add the "Vendor Names" from the "Vendor List" table to the "Vendor Name" in my Budget form.
I have tried everything I can to do this.....my latest attempt :
It is quite possible that one of the names used here are ambiguous. MS-Access routinely names an object on the form with a name equal to the name of the database field it refers to... and thereby routinely gets itself confused. [Vendor List], for example, could refer both to a database field and a control on the form. You'd suppose that MS-Access would be able to handle the ambiguity and in some places it can, some places it can't. Try fiddling with object-names on the form.
suggestion 1: make your life easy and avoid spaces & hyphens in names (names of tables/fields/forms/controls/reports/queries).
InitialCapitalisationOfEachWord is the easiest to read (..for me)
underline_between_words works but looks ugly and is tough to read.
suggestion 2: if you ignore suggestion 1, enclose all your names in