Opening A New Record in a Subform

[michaelb]

Hello All,

I want to setup a Subform as a entry form for a table record. The main form has a combobox that selects the record I want and the subform is updated. I want the subform to start with a blank record for the selected person in the main form. At this point I am hitting the Blank Record Button on the bottom of the subform to achieve this. I looked in several places including the macro builder, but did not find an answer.



Please Help,

Thank You

[alansidman]

Is your subform in datasheet view, continuous view or normal form view.

Alan

[michaelb]

It is in the normal view

[michaelb]

Hello Alansidman,

I used the following command in the On Current event for the subform and it is working. DoCmd.GoToRecord , , acNewRec

Thanks for your help

[alansidman]

Good News. Excellent