By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,294 Members | 2,645 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,294 IT Pros & Developers. It's quick & easy.

Subforms not opening in Add Mode

P: 33
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
Dec 19 '06 #1
Share this Question
Share on Google+
3 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
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
Dec 20 '06 #2

P: 33
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?
Dec 20 '06 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
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.

Expand|Select|Wrap|Line Numbers
  1. DoCmd.OpenForm "FormName"
Will open the form

If you need anything else please clarify the situation further

Mary
Dec 20 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.