Re: Creating filtered Drop Down / Combo Lists
- From: "Dirk Goldgar" <dg@xxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 13 Jun 2005 17:51:11 -0400
"Bmistry" <Bmistry@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:26094D3A-C959-4869-9800-C82E1125932D@xxxxxxxxxxxxx
> Hi,
>
> I am trying to improve the functionality of my form by providing a
> filtered combo boxes.
>
> I have 2 tables
>
> School Name (School ID, School Name)
> Course Name (Course ID, School ID, Course Name)
>
> I want my users to be able to select a school and then the Course
> Name Combo only provide them with the Courses that are available at
> that school. Is this possible?
>
> I am pretty new at coding in Access, so please provide details if
> coding is involved.
>
> Any help is much appreciated.
>
> Thanks
>
> Bhavini
This page shows two methods for doing what you ask:
http://www.mvps.org/access/forms/frm0028.htm
Forms: Limit content of combo/list boxes
Post back if that doesn't explain it clearly enough.
--
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)
.
- References:
- Creating filtered Drop Down / Combo Lists
- From: Bmistry
- Creating filtered Drop Down / Combo Lists
- Prev by Date: Creating filtered Drop Down / Combo Lists
- Next by Date: Transparent Background for Form
- Previous by thread: Creating filtered Drop Down / Combo Lists
- Next by thread: Re: Creating filtered Drop Down / Combo Lists
- Index(es):
Relevant Pages
|
