DLOOKUP SYNTAX 1

[mgbeye]

I have set up a dlookup function, but it keeps returning an error message.

Me.PF_size = DLookup("[preform_size]", "Preform to Bottle SF and Preform Usage", "[Bottle IMS] =" & Me.bottleIMS)

PF_size is the name of the txtbox I want it displayed in
Preform_size is the field I want returned from the table
Preform to bottle... is the table name
[bottle IMS] is the field name in the table
bottleims is the txtbox name

Can anyone help???

Thanks

 

[Telsa]

are you sure that [bottle ims] and me.bottleims are the same data type? Mary

Rule 1: Don't sweat the small stuff.
Rule 2: EVERYTHING is small stuff!! X-)

 

[mgbeye]

that doesnt seem to be the problem. They are both set as text. Any other suggestions?

 

[Telsa]

What exactly is the error message??? Mary

Rule 1: Don't sweat the small stuff.
Rule 2: EVERYTHING is small stuff!! X-)

 

[Telsa]

It also may be having a problem with the table name. Spaces can confuse it sometimes. Mary

Rule 1: Don't sweat the small stuff.
Rule 2: EVERYTHING is small stuff!! X-)

 

[mgbeye]

This is the error message.

"Run-time error '64479'
The expression you entered as a query parameter produced this error. 'The object doesn't contain the Automation object 'BOT30026'."


BOT30026 is a valid bottle IMS.

Thanks again

 

[Telsa]

Try creating a variable and point the form's field data to it and use it instead in the syntax. Mary

Rule 1: Don't sweat the small stuff.
Rule 2: EVERYTHING is small stuff!! X-)

 

[JoeMiller]

You need single quotes because of the data type being returned (text). Try this:

[tt]
Me.PF_size = DLookup("[preform_size]", "Preform to Bottle SF and Preform Usage", "[Bottle IMS] = '" & Me.bottleIMS & "'&quot
[/tt]

HTH


Joe Miller
joe.miller@flotech.net

 

[Telsa]

Joe is right. I didn't even see that before (ah.. the little things!) *G* Mary

Rule 1: Don't sweat the small stuff.
Rule 2: EVERYTHING is small stuff!! X-)