QBF Criteria error

[rt310]

So far my criteria looks like this: like forms![searchform].[qauthor1] & "*"
however, when i enter the criteria into a search box and run it, it prompts me with a paramaters box and i have to enter the info AGAIN. did i mess up the code or something?

[June7]

Don't know. Code looks good but just don't know enough about your db. If you want to provide db for analysis, follow instructions at bottom of my post.

[rt310]

Don't know. Code looks good but just don't know enough about your db. If you want to provide db for analysis, follow instructions at bottom of my post.

Form is "test", query is "authors query"

[June7]

Then the criteria in query should be:

Like [forms]![test]![qauthor1] & "*"

[rt310]

Thx, it works fine now. Another question: is it possible to create a button which clears the search terms? I've seen a 'clear parameters' button but don't know where it is.

[June7]

You have seen demonstration for a 'clear parameters' button but don't remember where?

The code is simply to set the textboxes to null or empty string, like:

Me.qauthor1 = Null