Re-Bound recordset to the form without closing it.

S

Sophie

I have a criteria Form will generate a SearchResultQuery.
A result form's datasource is based on SearchResultQuery.
If I don't close the result form before I do another
search, the form will still display previous result.
How do I re-bound all the text box on the result form to
display new result?

Thanks,

sophie
 
A

Andi Mayer

I have a criteria Form will generate a SearchResultQuery.
A result form's datasource is based on SearchResultQuery.
If I don't close the result form before I do another
search, the form will still display previous result.
How do I re-bound all the text box on the result form to
display new result?
Click to expand...
do you think on Requery?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Link a text box based on drop down box with four options MS Word 365 0
recordset vs collection 2
HELP: Display search results in footer section in a split form 0
Unable to display values in 2nd list box from 1st list box selection 2
Order of Events using the built in form Close Button 4
Requery a form 1
Print A For (docm), Send Email Attachment And Close For Without Saving 2

Top