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 » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

*Form Sub-field ?



 
 
Thread Tools Display Modes
  #1  
Old December 27th, 2006, 08:24 PM posted to microsoft.public.access.gettingstarted
yamefui
external usenet poster
 
Posts: 17
Default *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  
Old December 27th, 2006, 08:53 PM posted to microsoft.public.access.gettingstarted
brian b
external usenet poster
 
Posts: 17
Default *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  
Old December 27th, 2006, 09:22 PM posted to microsoft.public.access.gettingstarted
yamefui
external usenet poster
 
Posts: 17
Default *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  
Old December 27th, 2006, 10:58 PM posted to microsoft.public.access.gettingstarted
yamefui
external usenet poster
 
Posts: 17
Default *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

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 10:30 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.