Search Form Help

[Jlacey91]

Hi,



I've had trouble filtering a form on opening so as a way around this I set up a "Search Form" where a user enters the relevant "Driver Number" they are looking for and hits the "Run" button which opens the original form but now filtered.

This seemed to work perfectly fine at first but now the filtered object in my query is not recognised and I'm asked to re-enter Parameter value when run.


Any ideas why it's not finding the correct value?

My criteria is:

Like [Forms]![DepositCheck1].[DriverNo] & "*"


Thanks for your help.
Jamie

[orange]

You may get some ideas from this youtube video by Steve Bishop.

[alansidman]

Or maybe this one

http://www.datapigtechnologies.com/f...tomfilter.html

[June7]

LIKE operator and wildcard don't work with number values. Is DriverNo text or number type?

I NEVER use dynamic parameterized queries.

I prefer http://www.allenbrowne.com/ser-62.html

[Jlacey91]

LIKE operator and wildcard don't work with number values. Is DriverNo text or number type?

I NEVER use dynamic parameterized queries.

I prefer http://www.allenbrowne.com/ser-62.html

Thank you.

The DriverNo is a combination of text and numbers.

If I open the form on it's own type a value and hit search it works perfectly fine. When I add the form to my main form and run the search it does not recognise the value and I have to re-enter it?

[June7]

I suppose it's because the form referencing is no longer valid. Have to reference through the main form. I NEVER use dynamic parameterized query.

[June7]

You have two threads running on this same topic. Pick one and stick with it. You are getting basically same information in both. I should either merge them or delete one.