New subform record when creating new record in form

[MadeofCake]

Hi

I have a form on which people will enter new project details, including budget information which is held on a sub form.

The problem I am having is that when I enter a new record on the main form, the subform does not automatically generate a new record for me to add information into the budget area. Additionally when I enter one record in the budget subform i want it to generate another record space so that i can add further records.

I assume that i need to do this with code or a macro?

Very grateful for any help.

Thanks
Clare

 

[CEH]

No code or macro should be needed if the forms are linked. You should be going from a ONE (on your mainform) to a MANY (on your subform)..
Check the "Link child field" and "Link Master Field" on your "DATA" tab of the subform....... You should see your PK of the main form.... Something like "ProjectDetailsID" or what ever you are calling it. Would be PK on the query of your mainform and FK in the query of your subform.

 

[pbaldy]

Also, make sure the subform's Allow Additions property is Yes.

 

[MadeofCake]

Thanks for your replies, i hadn't set up the parent/child links correctly.

Really appreciate the help.

Cheers
Clare