Open form on new record

[Shadows1989]

Hi All,

Me again, this is something really simple, I hope, for you experts.

I have a homepage form that has a button on it called "Open Input Form", when the user presses this. The homepage form should close and the Input Form should open but on a new record, ready to add in new information. I also want the previous record to be viewable as I have a button that says previous record and another button that says next record.

I have this VBA code here:

Private Sub button_Open_Input_Form_Click()
DoCmd.GoToRecord acDataForm, "frm_Input_Form", acNewRec
End Sub

When I click on the button, I get a VB error that says:

Run-time error '2489' 

The object 'frm_Input_Form' isn't open.

What am I doing wrong? Surely it's something simple?



Thanks for any help!

[Shadows1989]

Managed to solve this:

Private Sub button_Open_Publisher_Setup_Click()    
DoCmd.OpenForm "frm_Publisher_Setup", acNormal, "", "", , acNormal
DoCmd.GoToRecord , "", acNewRec
End Sub

So this can be solved too .

[pbaldy]

If you're only going to add records, there's an argument of OpenForm that will open the form in data entry mode. The advantage would be that it wouldn't pull all the records over the network.

[Shadows1989]

If you're only going to add records, there's an argument of OpenForm that will open the form in data entry mode. The advantage would be that it wouldn't pull all the records over the network.

Hi,

I did try that initially but the aim is to add new while also being able to see the old, so I used the above code in my previous reply, which works a treat. Modified it a bit more so that it closes the initial form after opening the Input.

[pbaldy]

I must be blind and didn't see that you mentioned wanting previous records available. Sorry about that.

[Shadows1989]

I must be blind and didn't see that you mentioned wanting previous records available. Sorry about that.

No problem at all bud .