Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

On Close form not saving

Status
Not open for further replies.

Razor1

IS-IT--Management
Nov 21, 2002
81
US
I am changing the row source on a Multi Select List Box and then saving the form and then reopening the form. When I close the reopened form a dialog box opens and asks if I want to save the changes. There has been no changes to the form since I opened it.

Here is the code I am using:
DoCmd.OpenForm "Form1", acDesign
Forms!Form1!Choice.RowSource = strSQL
DoCmd.Close acForm, "Form1", acSaveYes
DoCmd.OpenForm "Form1"



Razor1
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top