Macro issue...closing current form

[xpun]

hey all

ok i have a macro set to a button(main menu ) on a customer entry form.

close
close
openform

the problem is when the button(main menu) is clicked while the customer entry form is in edit mode (with the little pencil in the left hand corner) I get a “field cannot be null error…” which prevents the macro from running.

if i change the macro to this it works,

runcommand : undo
close
close
openform

However it doesn’t work when the form is not in edit mode. An “undo is not available error…” message pops up.

is there any way to set some sort of conditional to fix this. Or suppress the error msg ???

any help is greatly appreciated
ACCESS 2003

[Nestor01]

hey all

ok i have a macro set to a button(main menu ) on a customer entry form.

close
close
openform

the problem is when the button(main menu) is clicked while the customer entry form is in edit mode (with the little pencil in the left hand corner) I get a “field cannot be null error…” which prevents the macro from running.

if i change the macro to this it works,

runcommand : undo
close
close
openform

However it doesn’t work when the form is not in edit mode. An “undo is not available error…” message pops up.

is there any way to set some sort of conditional to fix this. Or suppress the error msg ???

any help is greatly appreciated
ACCESS 2003

macro action>setwarnings, no

[xpun]

macro action>setwarnings, no

nope undo error pops up and the macro is stopped...

[xpun]

phew i finaly gave up on the macro and did it with vb..

I dont think the problem can be fixed in a macro.

Private Sub Command21_Click()
If Me.Dirty = True Then
RunCommand acCmdUndo
DoCmd.Close acForm, "customer entry"
DoCmd.OpenForm ("main")
Else
DoCmd.Close acForm, "customer entry"
DoCmd.OpenForm ("main")
End If
End Sub
 

[missinglinq]

Macros are very limited in what they can do. That's the reason that, with the exceptions of the Autoexec and AutoKeys macros, very few developers use them. They also have no provision for error handling, another huge handicap!

Linq ;0)>