If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Synchronized combo boxes in subforms
I can sync combo boxes in a form, but cannot get it to work on a subform. I
do not know VBA, so if you try to give me code, that won't help. I use macros and queries for everything, I haven't learned VBA yet. |
#2
|
|||
|
|||
Synchronized combo boxes in subforms
How are you syncing them on the form?
If the RowSource for the second combo box points to the first combo box to limit it, recognize that you cannot refer directly to controls on forms being used as subforms, you have to go via the parent form. Forms!NameOfParentForm!NameOfSubformControl.Form!N ameOfControlOnSubform Note that depending on how you added the subform, NameOfSubformControl might be different than the name of the form being used as a subform. -- Doug Steele, Microsoft Access MVP http://www.AccessMVP.com/DJSteele (no e-mails, please!) "Mac" wrote in message ... I can sync combo boxes in a form, but cannot get it to work on a subform. I do not know VBA, so if you try to give me code, that won't help. I use macros and queries for everything, I haven't learned VBA yet. |
#3
|
|||
|
|||
Synchronized combo boxes in subforms
The combo box works on the subform if you open the subform by itself... but
when embedded in the tabbed form it fails. Here is how it's set up. Form: card_info_form Tabbed form: TabCtl_card_info Tab: Exceptions Subform: exception_requests subform Independent field: exception_type Dependent field to exception_type: exception_category On the actual subform where it works, I'm syncing the fields with a query and macro like in the example file "How to synchronize combo boxes.accdb". "Douglas J. Steele" wrote: How are you syncing them on the form? If the RowSource for the second combo box points to the first combo box to limit it, recognize that you cannot refer directly to controls on forms being used as subforms, you have to go via the parent form. Forms!NameOfParentForm!NameOfSubformControl.Form!N ameOfControlOnSubform Note that depending on how you added the subform, NameOfSubformControl might be different than the name of the form being used as a subform. -- Doug Steele, Microsoft Access MVP http://www.AccessMVP.com/DJSteele (no e-mails, please!) "Mac" wrote in message ... I can sync combo boxes in a form, but cannot get it to work on a subform. I do not know VBA, so if you try to give me code, that won't help. I use macros and queries for everything, I haven't learned VBA yet. . |
#4
|
|||
|
|||
Synchronized combo boxes in subforms
seriously? I stumped you, or did you give up on me? I still cannot get
this to work, please advise. "Douglas J. Steele" wrote: How are you syncing them on the form? If the RowSource for the second combo box points to the first combo box to limit it, recognize that you cannot refer directly to controls on forms being used as subforms, you have to go via the parent form. Forms!NameOfParentForm!NameOfSubformControl.Form!N ameOfControlOnSubform Note that depending on how you added the subform, NameOfSubformControl might be different than the name of the form being used as a subform. -- Doug Steele, Microsoft Access MVP http://www.AccessMVP.com/DJSteele (no e-mails, please!) "Mac" wrote in message ... I can sync combo boxes in a form, but cannot get it to work on a subform. I do not know VBA, so if you try to give me code, that won't help. I use macros and queries for everything, I haven't learned VBA yet. . |
#5
|
|||
|
|||
Synchronized combo boxes in subforms
Sorry, I'm not familiar with the example file to which you're referring.
You'll have to provide the details of what you're doing. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Mac" wrote in message ... The combo box works on the subform if you open the subform by itself... but when embedded in the tabbed form it fails. Here is how it's set up. Form: card_info_form Tabbed form: TabCtl_card_info Tab: Exceptions Subform: exception_requests subform Independent field: exception_type Dependent field to exception_type: exception_category On the actual subform where it works, I'm syncing the fields with a query and macro like in the example file "How to synchronize combo boxes.accdb". "Douglas J. Steele" wrote: How are you syncing them on the form? If the RowSource for the second combo box points to the first combo box to limit it, recognize that you cannot refer directly to controls on forms being used as subforms, you have to go via the parent form. Forms!NameOfParentForm!NameOfSubformControl.Form!N ameOfControlOnSubform Note that depending on how you added the subform, NameOfSubformControl might be different than the name of the form being used as a subform. -- Doug Steele, Microsoft Access MVP http://www.AccessMVP.com/DJSteele (no e-mails, please!) "Mac" wrote in message ... I can sync combo boxes in a form, but cannot get it to work on a subform. I do not know VBA, so if you try to give me code, that won't help. I use macros and queries for everything, I haven't learned VBA yet. . |
Thread Tools | |
Display Modes | |
|
|