Query criteria based on string in a text field

[Pierkes]

Hi,

I have a query in which there is a text field called "name"
I have a form with a textfield called "name_client" in which the user can put in the (part of the) name of the client.

In the criteria part of the query i have;

Like "*" & [forms]![frm_client]![name_client] & "*"

But it will not filter on any part of the name of the client.
I would appreciate any suggestions on how to solve this.

Thanks and best regards,
Pierkes

[jforbes]

Are you getting an error or are no records returned? Are you being asked for a parameter when you run your query? Have you made sure that frm_client is running and has a value entered in for name_client? Have you tried typing ?[forms]![frm_client]![name_client] into the Immediate Window to see what it evaluates to?

[Pierkes]

Hijforbes,

Problem is not an error message but no records returned.
I'am not being asked a parameter when running the query,, the form is running, the field is filled.

I did not use a ? Nor do i know what you mean by this....can you explain a little more?
Thanks,
Pierkes

[jforbes]

You can go into the VBA Edtitor (alt+f11), open the Immediate Window (ctrl+g) and type in ?[forms]![frm_client]![name_client] and hit enter and will Access will attempt to evaluate it and spit out the results.

If you are still stuck with it, you can flip over to SQL View and copy and paste the SQL here so we can try to help you debug it.

[Pierkes]

Hi Jforbes,

Turns out, i was looking at the wrong field in the criteria part of the query...solved it!
Thanks for your help, it was much appreciated!

Pierkes