Re: Sub menus
- From: John W. Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sat, 16 Jun 2007 11:55:41 -0600
On Sat, 16 Jun 2007 10:31:01 -0700, Doug11046
<Doug11046@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I am trying to set up an Access database that will allow me to first look up
a catagory and from that category to next look up particluar items related to
that category.
The application involves 2000 or so items that that can be grouped into 20
or so categories. To try to pick 1 of 2000 items directly using combo boxes
is too time consuming and so the idea is that the user first picks a category
which then limits the combo box to only those items in that category.
Thanks for any help you can provide.
Use a Form with two combo boxes. The first combo box would list the categories
(let's call it cboCategory). The second combo would be based on a query of the
items table referencing cboCategory as a criterion:
=[Forms]![YourFormName]![cboCategory]
You'll need to Requery the item combo box in the AfterUpdate event of
cboCategory.
John W. Vinson [MVP]
.
- Prev by Date: HELP, HELP!!! CONVERT A DATA STRUCTURE IN C# TO A ACCESS DATABASE
- Next by Date: Re: HELP, HELP!!! CONVERT A DATA STRUCTURE IN C# TO A ACCESS DATABASE
- Previous by thread: HELP, HELP!!! CONVERT A DATA STRUCTURE IN C# TO A ACCESS DATABASE
- Next by thread: Re: SQL Server 2000
- Index(es):
Relevant Pages
|
