Saving a record form another form

[Harr777]

Greetings,

I am trying to write VBA code that would save the record that is currently in another From. I tried this:

Forms!frmMeterReads.DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
Forms!frmMeterReads.DoCmd.GoToRecord , , acNewRec

But I get an error when I execute this code from a button in another Form.

Any ideas?

 

[DeanWilliams]

Hi,

The DoCmd method is a member of the Application object not a Form's, so you can't use it like that.

Although I haven't tested this yet, I would guess that you could try selecting the other form then saving the record, i.e:

[COLOR=blue]DoCmd.SelectObject acForm, "frmOtherFormName"

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
DoCmd.GoToRecord , , acNewRec

DoCmd.SelectObject acForm, Me.Name
[/color]

HTH

Dean