Close Form changes data

[Richard1941]

I have created a form with a combobox for selecting one of several reports to generate. That part works fine. But I added a Close Form button to the form, and now every time I close the form, it changes the dropdown list of the combo box. How do I prevent the table that holds the list from being changed?

 

[jdraw]

Please show us the code involved.

 

[Richard1941]

Private Sub Command6_Click()
DoCmd.Close acForm, "frmCommitteeMembersReport"
End Sub

 

[jdraw]

I don't see how this would affect a table.

Here is a link to Martin Green's site that deal with selecting reports from forms etc.
http://www.fontstuff.com/access/acctut19.htm

 

[Richard1941]

Doesn't help. It only shows how to get to the report. I can do that. I can select the parameter I want and bring up the correct report in print preview mode. When I close the report, it goes back to the form. I can then bring up a different parameter and get a different report. Finally, I want to close the form, which I do by clicking on the Close Form button I put on the form. When I do that, the form closes, but not before it changes a value in the pull down list.

 

[RainLover]

If the ComboBox is used only for printing then delete the Control Source in the Properties Box.

Leave the rest as it is.

 

[Richard1941]

That worked! Many thanks.

 

[RainLover]

You are welcome.

That was an easy one.