Access 2007: Do you want to save the changes? when unloading a form 1

[ernigles]

Hi, i have a DB with two main forms, and a button in each of them for going from one to the other. SOmetimes, when i change from one to the other Access asks me if i want to save the changes in the objects: both forms, and some subforms of the form of origin.

Can anybody say if that can be handled and avoided? I am using access 2007 and i don't see the property Allow changes, for setting it to 'only in design view' which perhaps would solve the problem.

It doesn't occur in other Access versions.

Thanks in advance.

 

[TheAceMan1]

How are ya ernigles . . .

I don't have 2007 (won't even give clients the go ahead because of so many problems), but you can try the following:

[blue]   DoCmd.SetWarnings False
   [green]'your button code here[/green]
   DoCmd.SetWarnings True[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[ernigles]

Thanks TheAceMan1. That has worked.