Clear previous data from search

[cbramsey]

I have a form that has a box that will allow user to search by owner name.



They type in owner name and click the button and it executes the query to find all tickets with that owner name. My problem is, when they go back and search another name, it doesn't search the new name, it will only search the previous entry. If the close and reopen the data base then they can search again. I know there is some way to reset the query, but for the life of me I can't find it.

Thanks for any help.

[orange]

You could reset the "box" with a zero length string ("").
You might also consider using Find as you type approach, or a dropdown combo box with Owner names.
This would allow user to select a name and would avoid typos.

[cbramsey]

it is like I need to reset the query or something.

Here is a break down of the process

Type in owner name in form and click 'find by owner'.

Find by owner button feeds the owner name that was typed into the find by owner query and runs query

Form opens with all of the data from the query

When I return to the original form and enter another owner name and click the button it requeries the same owner that was searched for the first time. It is like I need a way to clear all of the data after each query. I have a button that returns to home from the form with the query data on it. is there a command I could put in that to clear the data?

[orange]

Can you post a copy of the database in zip format?

[cbramsey]

i can't unfortunately, too much personal identifying information involved

[davegri]

Perhaps you could post the code behind the 'find by owner' button and any other code, image that could help. It might be enough to give us a clue.

[orange]

Make a copy. Remove most of the data. Anonymize some names with Porky Pig, Donald Duck etc.
All we want to resolve is the textbox after a search, right?

All you need is 2 or 3 records.