Error with string syntax...

[imrosie]

Hello,
I'm getting syntax error with this, does anyone see a glaring problem? I thought it was fine, but the compiler is complaining.
thanks in advance.

Private Sub custname_AfterU pdate()
Me.FilterOn = True
Me.Filter = "CustomerID =" & custacct
Me.Requery
End Sub

[Stwange]

Hello,
I'm getting syntax error with this, does anyone see a glaring problem? I thought it was fine, but the compiler is complaining.
thanks in advance.

Private Sub custname_AfterU pdate()
Me.FilterOn = True
Me.Filter = "CustomerID =" & custacct
Me.Requery
End Sub

Assuming custacct is a number, the compiler might be complaining about a type conversion error (I'm not sure if this language does or not, but it's worth a try).

Try:
Me.Filter = "CustomerID =" & CStr(custacct)

If that fails, tell me where Filter is declared or what it is.

[FishVal]

Hello,
I'm getting syntax error with this, does anyone see a glaring problem? I thought it was fine, but the compiler is complaining.
thanks in advance.

Private Sub custname_AfterU pdate()
Me.FilterOn = True
Me.Filter = "CustomerID =" & custacct
Me.Requery
End Sub

Hi, Rosie.

What is custacct? Global variable, form control name?

[imrosie]

Hi, Rosie.

What is custacct? Global variable, form control name?

Hi FishVal,

custacct is a form control name.thanks

Rosie

[FishVal]

Hi FishVal,

custacct is a form control name.thanks

Rosie

Try to reference it through the form object - Me.custacct or Me!custacct, as you like.

And, BTW, are you sure control name is not misspelled?
This case VBA compiler will automatically dim it as Variant or raise an error if you have "Option Explicit" statement in the module header.

[imrosie]

Try to reference it through the form object - Me.custacct or Me!custacct, as you like.

And, BTW, are you sure control name is not misspelled?
This case VBA compiler will automatically dim it as Variant or raise an error if you have "Option Explicit" statement in the module header.

FishVal,,,
Your observation was right on,,,,somehow I had 'custacct', when it should have been 'custname'..... ..

Also I added the CStr(custname) as suggested by Stwange...it's working.
thanks for your help..forgive the mistake.
Rosie

[FishVal]

FishVal,,,
Your observation was right on,,,,somehow I had 'custacct', when it should have been 'custname'..... ..

Also I added the CStr(custname) as suggested by Stwange...it's working.
thanks for your help..forgive the mistake.
Rosie

Actually "CStr" is not needed this case, bkz "&" operator unlike "+" concatenates all variable types with string.
For example try in Immediate window
? "qwerty" +1
? "qwerty" & 1

[imrosie]

Actually "CStr" is not needed this case, bkz "&" operator unlike "+" concatenates all variable types with string.
For example try in Immediate window
? "qwerty" +1
? "qwerty" & 1

FishVal,

You're right...thanks so much.
Rosie