kingsgambit
Registered User.
- Local time
- Today, 01:53
- Joined
- May 27, 2001
- Messages
- 134
I have build a search form.
On it are six textboxes each for each field of a record, below is a listbox with a query attached, if the user enters text into one of the fields the listbox will show results.
I want to have a button so the user can search again, the button would clear all the text boxes and the list box ready for the new search, if I put code behind the button so that
Me.textbox.value="" I get an error saying textbox can not contain nullstring.
I can have a button that closes and opens form, but that does not look very good and is not really the answer
Any ideas how to clear all textboxes and listbox.
On it are six textboxes each for each field of a record, below is a listbox with a query attached, if the user enters text into one of the fields the listbox will show results.
I want to have a button so the user can search again, the button would clear all the text boxes and the list box ready for the new search, if I put code behind the button so that
Me.textbox.value="" I get an error saying textbox can not contain nullstring.
I can have a button that closes and opens form, but that does not look very good and is not really the answer
Any ideas how to clear all textboxes and listbox.
