I want to open my contacts form to a new form

[Susan Boulio]

I'm trying to create a form that opens to a new record but will allow me to update existing records if I need to. In the form properties Event tab, On Load, the code I am using is:

DoCmd.GoToRecord, acDataForm, "frmAlumniContactInfo", acNewRec

but the record still opens to the first record in the data set

[NeoPa]

I'm not sure about this because in my testing I couldn't even get any code in the Form_Load() event procedure to fire. That's another problem though I expect.

In your case I suspect the extra comma (,) is confusing matters. You should try instead :

DoCmd.GoToRecord Record:=acNewRec

These methods are designed to be able to be used to control other objects as well, but generally the current object is required, in which case the type and name can be omitted.

Let me know if the code works for you. As I say - I couldn't even get the event procedure to run anything. I expect that was something silly I have in my testing, but curious anyway.