New record in subform with Access 2000

[Del]

I have a parent form with no record source. On this parent form i have a
subform whose record source is a table. How can i direct the subform to a
new record in response to an event on the parent form?

 

[John W. Vinson]

I have a parent form with no record source. On this parent form i have a
subform whose record source is a table. How can i direct the subform to a
new record in response to an event on the parent form?

You could use code like:

DoCmd.GoToRecord acForm, Forms!mainformname!subformname.Form, acNewRecord

 

[Stuart McCall]

You could use code like:

DoCmd.GoToRecord acForm, Forms!mainformname!subformname.Form, acNewRecord

Hi John

That would need to be:

DoCmd.GoToRecord acForm, Forms!mainformname!subformname.Form.Name,
acNewRecord

 

[John W. Vinson]

Hi John

That would need to be:

DoCmd.GoToRecord acForm, Forms!mainformname!subformname.Form.Name,
acNewRecord

Knew I shoulda checked... thanks Stuart!