K
KarenMSX
Guest
Is there a way I can access my subforms by clicking on a command button rather than having them always open on the parent form? If so, how would you recommend I do that? All input is greatly appreciated. Thanks!
Let me give you two options. There are probably more:
1. Have the "sub" forms be pop-up forms that open on the Command Button click. You can then use the "Where" clause of DoCmd.OpenForm to dictate which records should appear, making it behave like a subform.
2. On my main form, I have a subform whose Control Source I change with a click in a list box. In other words, many subforms are displayed in the same control (place) on the form. If you have User-Level Security, there are issues (you need to give everyone design permissions on the subforms) but that may be a way around your problem.
HTH
1. Have the "sub" forms be pop-up forms that open on the Command Button click. You can then use the "Where" clause of DoCmd.OpenForm to dictate which records should appear, making it behave like a subform.
2. On my main form, I have a subform whose Control Source I change with a click in a list box. In other words, many subforms are displayed in the same control (place) on the form. If you have User-Level Security, there are issues (you need to give everyone design permissions on the subforms) but that may be a way around your problem.
HTH
Graham T
Registered User.
- Local time
- Today, 12:21
- Joined
- Mar 14, 2001
- Messages
- 300
There are options available to perform this action when using the form wizard to create forms based on multiple tables.
You can choose to view data by using a form with subforms or using linked forms.
Clicking on the command button takes you to the linked form.
HTH
You can choose to view data by using a form with subforms or using linked forms.
Clicking on the command button takes you to the linked form.
HTH
Similar threads
Solved
Select Last Record
