Add new record to other form.

[teirrah1995]

I'm sure the answer is here, but I don't know what to search for.

I have an object on form A. When it is clicked, this happens.

Private Sub Command1_Click()

DoCmd.GoToRecord , , acNewRec

End Sub

I want the new record not to be on the current form, but on form B. I feel a bit daft as I'm sure the answer is simple.

[rpeare]

if you look at the help that pops up when you type in

docmd.gotorecord

The first option is what type of object it is (in your case acdataform)
the second option is what is the object name (in this case your form_b)

so you would have something like

DoCmd.GoToRecord acDataForm, "Form_B", acNewRec

[teirrah1995]

Thanks for the reply
I tried this, and it told me off because "The object "Patient" (Form B) isn't open". I opened Patient and tried again, and got the same message.

[rpeare]

is the form open when you try to go to a new record?

if not you have to open it first.

Without knowing what your code says I can't tell you what the problem is.

[teirrah1995]

That works, thanks. I've told it to open my form before adding a new patient.