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
|
|||
|
|||
*Form Sub-field ?
Example:
1. I select 'Homeowner' as one of my options in a list or combo box that I have created for a field named 'Category' (which will contain about 10 other options as well). 2. I would then like to be able to identify the housing subdivision (possibly dozens or hundreds of options), i.e. Fox Run, where this Homeowner resides. How can I require that users who input data ensure they select a proper housing subdivision name when the 'Homeowner' field has been chosen first without making 'Subdivision' a separate field? Is there a way to link them so upon choosing 'Homeowner' the user must immediately choose a subdivision? Thank you for your assistance. -- jon |
#2
|
|||
|
|||
*Form Sub-field ?
If I'm understanding your question correctly - the information you need can
be found at: http://www.mvps.org/access/forms/frm0028.htm "yamefui" wrote: Example: 1. I select 'Homeowner' as one of my options in a list or combo box that I have created for a field named 'Category' (which will contain about 10 other options as well). 2. I would then like to be able to identify the housing subdivision (possibly dozens or hundreds of options), i.e. Fox Run, where this Homeowner resides. How can I require that users who input data ensure they select a proper housing subdivision name when the 'Homeowner' field has been chosen first without making 'Subdivision' a separate field? Is there a way to link them so upon choosing 'Homeowner' the user must immediately choose a subdivision? Thank you for your assistance. -- jon |
#3
|
|||
|
|||
*Form Sub-field ?
Yikes. I'm a relative newb and honestly don't understand that explanation.
Thanks for the response however. I'll keep searching. If there's another way, even if it's more cumbersome, I'm willing to try it. -- jon "brian b" wrote: If I'm understanding your question correctly - the information you need can be found at: http://www.mvps.org/access/forms/frm0028.htm "yamefui" wrote: Example: 1. I select 'Homeowner' as one of my options in a list or combo box that I have created for a field named 'Category' (which will contain about 10 other options as well). 2. I would then like to be able to identify the housing subdivision (possibly dozens or hundreds of options), i.e. Fox Run, where this Homeowner resides. How can I require that users who input data ensure they select a proper housing subdivision name when the 'Homeowner' field has been chosen first without making 'Subdivision' a separate field? Is there a way to link them so upon choosing 'Homeowner' the user must immediately choose a subdivision? Thank you for your assistance. -- jon |
#4
|
|||
|
|||
*Form Sub-field ?
Here's a response that I received from another user in the event anyone else
wants to try this. Thanks. ------------------------------------------------------------------------------------------------ You can have a combo box make another combo box visible depending on the value selected in the first combo box. In your case you would hide the subdivision combo box and then when 'Homeowner' is selected it the first combo box. Code similar to this in the After Update event of the first combo box should do the trick: If Me.NameOfComboBox = "Homeowner" Then Me.NameOfNextComboBox.Visible = True Else Me.NameOfNextComboBox.Visible = False End If Depending on how you set up your form this code may also be needed in the On Current event of your form. "yamefui" wrote: Yikes. I'm a relative newb and honestly don't understand that explanation. Thanks for the response however. I'll keep searching. If there's another way, even if it's more cumbersome, I'm willing to try it. -- jon "brian b" wrote: If I'm understanding your question correctly - the information you need can be found at: http://www.mvps.org/access/forms/frm0028.htm "yamefui" wrote: Example: 1. I select 'Homeowner' as one of my options in a list or combo box that I have created for a field named 'Category' (which will contain about 10 other options as well). 2. I would then like to be able to identify the housing subdivision (possibly dozens or hundreds of options), i.e. Fox Run, where this Homeowner resides. How can I require that users who input data ensure they select a proper housing subdivision name when the 'Homeowner' field has been chosen first without making 'Subdivision' a separate field? Is there a way to link them so upon choosing 'Homeowner' the user must immediately choose a subdivision? Thank you for your assistance. -- jon |
Thread Tools | |
Display Modes | |
|
|