Popup Box Related To Query Search

  • Thread starter Thread starter Argonaught
  • Start date Start date
A

Argonaught

Guest
I have created a query to search for authors and display a report based on the information.
This all works fine but the popup box displays the parameters i entered to run the query, i would like to change it to someting like "Enter Author Name" , but i cannot find any option to do this,
i have changed field properties etc but with no effect.
Im sure this is a simple fix but ive been going round in circles for ages so any help would be most appreciated.

Cheers
Argonaught
 
In the criteria for the author field in your query, enter this

[Enter Author Name]

which will prompt users to enter the author's name.

You can also use wild cards by entering (again, in the Criteria for the author name field):

Like "*" & [Enter Author Name] & "*"
 
in my criteria box i have:[Forms]![Books1form]![Author]
ie the field i want searched by the query.
Is this wrong, it works fine, the only problem is the popup box displays "[Forms]![Books1form]![Author]"
I tried not entering this in the criteria and my query acted up.
 
Sorry i replied before i had played about a bit more, you right
I didnt need to put all that junk in there, its all sorted and working fine, thanks alot

Argonaught
 

Users who are viewing this thread

Back
Top Bottom