Dlookup Problem

[gheyman]

Not getting a result

On a form I want to look for a value in a separate table based on a value in a Text box on this form

My table Name is: tblRFPStageLst
I want the Value from: Catagory1
Looking for a Match to the Field: RFP_Stage

The Textbox on the Form is: RFP_StageX

Here is the last thing I tried: =DLookUp("Catagory1","tblRFPStageLst","RFP_Stage=RFP_StageX")

Thanks

 

[xenou]

double check the name of the control too - it has to be spelled exactly right.

 

[xenou]

Looks like these work (assume your form is named myForm):
=DLookUp("Catagory1","tblRFPStageLst","RFP_Stage='" & [RFP_StageX] & "'")
=DLookUp("Catagory1","tblRFPStageLst","RFP_Stage='" & [Forms]![myForm]![RFP_StageX] & "'")

Guess it doesn't like the Me part if you are not actually in a code module.

 

[Joe4]

Guess it doesn't like the Me part if you are not actually in a code module.

Ah, yes. Good catch xenou.

 

[gheyman]

Its bound. Its a Listbox the user selects when completing information on the form.

 

[Joe4]

I think if your remove the "[Me]." part like xenou mentioned, that should work. You would use that naming convention in a VBA Module, but not in a Control Source.
Sorry I led you down the wrong path with that part.