Returning novice user
I need to prove the principle of DLookUp in a small example database before using it elsewhere.
I have set up two tables.
tbl_Name
contains two fields of standing data
Number
(alphanumeric, aannnn where a = alphabetic and n = numeric character)
Name
containing a text string
tlkp_Test
contains two fields
LocNumber
where the user has a choice from a drop down list populated from tbl_Name field Number (this part is working!)
LocName
where the DLookUp should retrieve the Name value in tbl_Name that matches the number the user chose in tlkp_LocName field LocNumber
IncorrectDLookUp code
Code:
SELECT DLookUp([tbl_Name]![Name],[tlkp_Test]![LocNumber],[tbl_Name]![Number]) AS Expr1;
I have tried many sources of guidance, help and browsed this forum, but have to confess myself beaten. Various attempts have resulted in a request for parameters, error messages about incorrectly defined data sources or blank refusal to work.
I'd be really grateful for your help so that I can make progress with the work that depends on this.