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  

nesting values in a combo box



 
 
Thread Tools Display Modes
  #1  
Old February 23rd, 2006, 08:31 AM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default nesting values in a combo box

Using Microsoft Access 2003. I already have a combo box in use to relate
values for subjects. I now want to isolate one of the values within the drop
down list and create another drop down list using that value.
  #2  
Old February 23rd, 2006, 12:21 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default nesting values in a combo box

I like to create a query as the source for the second combo box and use the
first combo as a criteria. You can use the Build command (right-click in the
criteria box) or simply type in: [Forms]![YourFormName]![YourCombo1]
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

"Dave Nelson" Dave wrote in message
...
Using Microsoft Access 2003. I already have a combo box in use to relate
values for subjects. I now want to isolate one of the values within the

drop
down list and create another drop down list using that value.



 




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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Refreshing a combo box with values entered in another tabbed subfo Ed880 Using Forms 0 October 21st, 2005 03:13 PM
Nesting Combo Boxes /Returning an Array ELMONDO SNITHER General Discussion 1 June 30th, 2005 01:15 AM
Storing values when using one combo box based on another? Wolf General Discussion 1 June 13th, 2005 02:43 PM
combo box values DW via AccessMonster.com Using Forms 1 May 11th, 2005 07:42 AM
Combo box returns numeric values Joe Running & Setting Up Queries 5 December 1st, 2004 03:03 PM


All times are GMT +1. The time now is 05:46 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.