Clear/Reset form query results

[bigtime]

Hello,

I've got a search form that returns its results from a query. After a user searches and views their results, I need to have a button that will allow them to reset the results to a blank form.

I was able to create a reset button that resets the search input box but I'm not able to figure out how to reset the other result text boxes.

I've attached my database file if anyone could take a look.

Thanks in advance!

Tim

 

[Beetle]

You can't really clear those text boxes because they are bound to fields in a read only record set (the underlying totals query). You could use filtering instead, the only problem there is that when you filter for no results the controls in the detail section lose visibility. Not sure if that will meet your needs or not, see attached file.

 

[bigtime]

That's awesome! Thank you so much!!!!!!! I've been working on that for weeks.

Tim

 

[bigtime]

I found one issue. If I search for a random number that is not found, the not found message pops up but then it still displays the 1st record. Anyway of preventing that?

Thanks,

Tim

 

[Beetle]

Inside the section of the If..Then block where the message is displayed if no match is found, place code to filter for something that isn't in the record set, just like in the code for the Reset button (you could just copy it from there). Just make sure you put it inside that same section of the If..Then block.

 

[bigtime]

That worked perfectly, thanks again!!!!!