Populating text box based on selection in two combo boxes

[SHAWTY721]

I have a form that contains two combo boxes that are related to each other. I
need to find a way to populate my text box based on the criteria of the two
combo boxes so the appropriate number appears in the text box. I created a
DLookup Function that works when I run it using Query designer but when I add
it to the Control Source of my text box it returns nothing. I'm not sure if
this is because the second combo box values are based on the selection made
from the first comb box.

 

[John W. Vinson]

I have a form that contains two combo boxes that are related to each other. I
need to find a way to populate my text box based on the criteria of the two
combo boxes so the appropriate number appears in the text box. I created a
DLookup Function that works when I run it using Query designer but when I add
it to the Control Source of my text box it returns nothing. I'm not sure if
this is because the second combo box values are based on the selection made
from the first comb box.

Correct the error in your code or your query.

If you'ld like help doing so, please post the code and/or the SQL view of the
query. We can't see it from here.

John W. Vinson [MVP]

 

[SHAWTY721]

Here is the DLookup I'm trying to use that works in the query designer but
not when I use it as the Control Source for the text field

=DLookUp("[BranchNumber]","[tblAllADPCoCodes]","[ADPCompany]= '" &
[cboADPCompany] & "' And [LocationNumber]= '" & [cboLocationNo] & "'")

I have a form that contains two combo boxes that are related to each other. I
need to find a way to populate my text box based on the criteria of the two

[quoted text clipped - 3 lines]

this is because the second combo box values are based on the selection made
from the first comb box.

Correct the error in your code or your query.

If you'ld like help doing so, please post the code and/or the SQL view of the
query. We can't see it from here.

John W. Vinson [MVP]

 

[John W. Vinson]

Here is the DLookup I'm trying to use that works in the query designer but
not when I use it as the Control Source for the text field

=DLookUp("[BranchNumber]","[tblAllADPCoCodes]","[ADPCompany]= '" &
[cboADPCompany] & "' And [LocationNumber]= '" & [cboLocationNo] & "'")

What's actually in the fields ADPCompany and LocationNumber? Are they Text
fields, or perhaps numeric ID's concealed by Lookup Fields? Do the values in
the fields match the values in the bound column of the combo boxes? Do you
need to Requery this control in the AfterUpdate events of the combos?

John W. Vinson [MVP]