applyFilter problem

[nicktred]

HI

im trying to filter a record set in a form and but doesnt seem to like the ApplyFilter function any ideas

DoCmd.ApplyFilter , "customer_id = '" & customer_id.Value & "'"

Cheers

Nick

 

[SgtJarrow]

Is the customer_id a string value? Because that is what you are asking for. To search for numeric entries:

DoCmd.ApplyFilter , "customer_id = " & customer_id.Value

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com

 

[RoyVidar]

If it's numeric, remove the text qualifiers.

[tt]DoCmd.ApplyFilter , "customer_id = " & customer_id.Value[/tt]

- else tell whats not working, error messages...

Roy-Vidar

 

[RoyVidar]

- must have been at the same time (and I did hit refresh;-))

 

[nicktred]

Thanks alot that did it thought it would be something simple like that.

Thanks again

Nick