More refresh troubles (1 Viewer)

[Hayley Baxter]

Hi Everyone

I've got a slight problem I'm hoping someone can help me with. I have a search form where user can select from various combo boxes, check boxes and text boxes then pull up the search results on a report. When the report opens I am hiding the search form but next time it is opened it still has the previous selections (probably because the form was never really closed in the first place) but I need to hide it when the report opens and I still need to refresh the form. I have tried me.refresh but it doesn't work.

I should add that I have tried closing the form as well then opening the report but this is not an option either as the form runs a query and the report is based on the query results. I found that when closing the form the data was not displayed on printouts.

Any suggestions the best place to put me.refresh. I can post the code if required.

Thanks
Hayley

 

[Newman]

You could close the form in the closing event of the report:
DoCmd.Close (acForm), "put the name of the form in here"

 

[Hayley Baxter]

Newman

Don't know why I didn't think of that - what a gem you are!!

Have a lovely weekend.

Merci

Hayley