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

 

[Joe4]

In your table, what data type is RFP_Stage?

If it is numeric, then your condition would look like:

[COLOR=#333333]"RFP_Stage=" & Me.RFP_StageX[/COLOR]

If test, then try:

[COLOR=#333333]"RFP_Stage='" & Me.RFP_StageX & "'"[/COLOR]

 

[gheyman]

Can you define numeric? The format is Short Text in the Table, but what's in there are numbers (1, 2 or 3)

Correction: RFP_Stage is Short Text (Text)

 

[Joe4]

Yep, the word "Text" is a dead giveaway.
An easy way to tell is if you are allowed to enter non-numeric values in it. If you are, it is not numeric.

All text entry values must be enclosed in quotes, as shown in my second example.

 

[gheyman]

This is what happens;

=DLookUp("Catagory1","tblRFPStageLst","RFP_Stage='" & [Me].[RFP_StageX] & "'")

Its changing this "RFP_Stage='" & Me.RFP_StageX & "'"

 

[Joe4]

That should be all right.
Does it work when you try it?

 

[gheyman]

No I get: #Name?

 

[Joe4]

The Textbox on the Form is: RFP_StageX

Is this a bound or unbound text box?

If unbound, when is it updated?

And is you calculation going into another unbound text box?

 

[gheyman]

I put this formula in an unbound text box in the Source Control

I triple checked all the spelling/names

 

[Joe4]

Sorry for maybe not being clear, but I was also inquiring about the "RFP_StageX" text box on your form in my previous post.
Is that a bound or unbound text box?
If unbound, how/when is that being populated?