I open a form in design view and change the row source for a multilist box. I then save the form and reopen it. When I close the form after reopening it the prompt to save the form appears. There has been no change in the form since the last save.
Any ideas on why it asks to save again?
Here is the code:
DoCmd.OpenForm "frm_BookingsRpt_Select", acDesign
Forms!frm_BookingsRpt_Select!SalesRepChoice.RowSource = strSQL
DoCmd.Close acForm, "frm_BookingsReport_Select", acSaveYes
DoCmd.OpenForm "frm_BookingsRpt_Select"
Thanks in advance for any help provided.
Razor1
Any ideas on why it asks to save again?
Here is the code:
DoCmd.OpenForm "frm_BookingsRpt_Select", acDesign
Forms!frm_BookingsRpt_Select!SalesRepChoice.RowSource = strSQL
DoCmd.Close acForm, "frm_BookingsReport_Select", acSaveYes
DoCmd.OpenForm "frm_BookingsRpt_Select"
Thanks in advance for any help provided.
Razor1