Need help with DLookup function for Access2003 1

[Spruce4U]

I cannot Dlookup function on a calculated control.

When I use the following line associated with a control event in Visual Basic, it works perfectly well:

VariableAm = DLookup("[sequence5_3_amorce]", "Liste_amorces", "[id_amorce]=" & Me![amorce_fwd])

However, when I try the same command line in the expression generator of the control (control source property), the generator tells me there is a syntax error in the expression:

=DLookup("[sequence5_3_amorce]", "Liste_amorces", "[id_amorce]=" & Me![amorce_fwd])

Could someone please help me with this?

Many thanks,

Sébastien

 

[lameid]

=DLookup("[sequence5_3_amorce]", "Liste_amorces", "[id_amorce]=" & [amorce_fwd])

The Me! doesn't belong in control sources only VBA.

 

[Spruce4U]

Thanks for the fast answer lameid, but even when I simplify the expression to any of the following, it won’t let me enter it (still a ‘syntax’ problem):

=DLookup("[sequence5_3_amorce]", "Liste_amorces", "[id_amorce]=100")
=DLookup("[sequence5_3_amorce]", "Liste_amorces", "[id_amorce]="&100)
=DLookup("[sequence5_3_amorce]", "Liste_amorces", "[id_amorce]=’"&100&"’")


???

 

[snyperx3]

Seems id_amorce is a string

=DLookup("[sequence5_3_amorce]", "Liste_amorces", "[id_amorce]='" & [amorce_fwd] & "'")


=DLookup("[sequence5_3_amorce]", "Liste_amorces", "[id_amorce]='100'")


-Pete

 

[Spruce4U]

No, it still won't work. Thanks nevertheless...

 

[lameid]

Add a control that just has amorce_fwd as the control source... Maybe it's value is causing problems. Maybe it is null, the wrong datatype, etc.?

Also, you are including the equal sign as part of the control source right?

Why dlookup? Would a combo box or a join work easier?