Dlookup with Combo Value

ootkhopdi

Registered User.
Local time
Today, 17:56
Joined
Oct 17, 2013
Messages
181
Hi. All

i have an access table
i m using Dlookup function for select data
in dlookup , i want to sel field as combo box value,
and i want when i change combobox value by select from list ,dlookup result will be change

how can i do it
 
Thanks Pual

But Autofill or select value from table is not my prob..
i think there should be more detail in my prob..
as

i have a dlookup formula which having field for select is (EMPID)
and a combobox or list which having more options to select..
i.e. EMPID, DOB,NAME etc..
so i want to change in my dlookup function is changed with selecting with combobox value or list value (which is combo box 1)

like..
DLookup("Value of Combobox 1" , "TableName" , "Criteria="Value of combobox2")so pls give me solution
 
You could try this one:

Supposing the name of your combo box is cboSelect, then you could perform the DLookup like this: DLookup("Field to Search", "Table Name", "Reference Field = "'" cboFind "'")

Hope this works.
 

Users who are viewing this thread

Back
Top Bottom