A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Synchronized combo boxes in subforms



 
 
Thread Tools Display Modes
  #1  
Old January 25th, 2010, 03:34 PM posted to microsoft.public.access.forms
Mac
external usenet poster
 
Posts: 330
Default 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  
Old January 25th, 2010, 04:46 PM posted to microsoft.public.access.forms
Douglas J. Steele[_3_]
external usenet poster
 
Posts: 3,143
Default 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  
Old January 29th, 2010, 06:56 PM posted to microsoft.public.access.forms
Mac
external usenet poster
 
Posts: 330
Default 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  
Old February 5th, 2010, 07:36 PM posted to microsoft.public.access.forms
Mac
external usenet poster
 
Posts: 330
Default 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  
Old February 5th, 2010, 10:52 PM posted to microsoft.public.access.forms
Douglas J. Steele[_3_]
external usenet poster
 
Posts: 3,143
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:26 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.