Subforms not opening in Add Mode

[godsent]

hi,
my prob is that ive done a form in which there are multiple sub forms,and when i click on "new" from the switchboard, only the first main form is displayed in the "add mode"....HOW DO I MAKE THE OTHER SUB FORMS IN 'ADD FORM 'TOO?

Eagerly waiting for your replies...
thnxx

[MMcCarthy]

hi,
my prob is that ive done a form in which there are multiple sub forms,and when i click on "new" from the switchboard, only the first main form is displayed in the "add mode"....HOW DO I MAKE THE OTHER SUB FORMS IN 'ADD FORM 'TOO?

Eagerly waiting for your replies...
thnxx

This is a bigger problem. It looks like you table relationships may not be right or else you haven't joined the subforms to your main form using the correct master/child relationship

Mary

[godsent]

This is a bigger problem. It looks like you table relationships may not be right or else you haven't joined the subforms to your main form using the correct master/child relationship

Mary

thanx mary,the subforms working perfect in add form..the relationship were ok, its just i had to reconsider how to link them in the subform...

Another prob is that, i have a form A,i need to click on a command button to reach another form B.Hence, when click the form in "ADD FORM",only the form A is in "ADD FORM", but not form B. I know i must write codes to do this (On click)...plz suggest how do i go about it..

Actually,its the first time am doing a system in Ms Access,hence will be grateful if i can get the codes. Is it the same as in VB.net?

[MMcCarthy]

thanx mary,the subforms working perfect in add form..the relationship were ok, its just i had to reconsider how to link them in the subform...

Another prob is that, i have a form A,i need to click on a command button to reach another form B.Hence, when click the form in "ADD FORM",only the form A is in "ADD FORM", but not form B. I know i must write codes to do this (On click)...plz suggest how do i go about it..

Actually,its the first time am doing a system in Ms Access,hence will be grateful if i can get the codes. Is it the same as in VB.net?

If FormB has the Data Entry Property set to No then it won't open in Add mode.

DoCmd.OpenForm "FormName"

Will open the form

If you need anything else please clarify the situation further

Mary