Save Record On Another Form Via Code

[Paul]

Hi,

I am trying to save a record on a parent form using code.

The code is basically.

me.form.parent.setfocus
runcommand accmdsaverecord

This always results in an error "record cannot be saved now" and the record
remains unsaved.

I have added the Save Record button to the toolbar, and that saves the
record just fine (so it is not a case of mandatory fields not being
completed).

What are alternate ways in code of saving the record currently displayed on
a given form?

As the Save Record button is not on the standard menus (you have to
customise) docmd domenuitem is not going to help.

I'm about to resort to a Shift+Return via sendkeys, but that is pretty
nasty.

Any suggestions would be greatly appreciated.

TIA

Paul

 

[Allen Browne]

You could try:

Me.Parent.SetFocus
Runcommand acCmdSaveRecord

Better still:

With Me.Parent
If .Dirty Then
.Dirty = False
End If
End With

 

[Paul]

Thanks Allen I'll give that a try.

I've discovered that the problem I was having is that you cannot do a save
after just setting the focus to the form (with the runcommand version), you
have to set the focus to a control on the form - don't know why, but it is a
pain as you have to cycle through the controls until you can find one that
can accept the focus (not locked, disabled, invisible, etc).

I'll give your suggestion a try.

Thanks

Paul

 

[Paul]

Your suggestion works great - thank you.

Thanks Allen I'll give that a try.

I've discovered that the problem I was having is that you cannot do a save
after just setting the focus to the form (with the runcommand version), you
have to set the focus to a control on the form - don't know why, but it is a
pain as you have to cycle through the controls until you can find one that
can accept the focus (not locked, disabled, invisible, etc).

I'll give your suggestion a try.

Thanks

Paul