Choosing different options

B

bigbadbess24

Registered User.

Local time

Today, 04:52

Joined

Mar 9, 2006

Messages

83

• May 2, 2006

• #1

I am trying to make a form that will allow me to make several selections and run a report. I want to be able to select from a list of Grade Levels, 9th, 10th, 11th and 12th. After I have picked my grade level or selected more then 1 grade level I want to be able to choose from a drop down list of school district. After I have choosen my grade level and my school district I want to run my report. How do I do that?

 

C

CEH

Curtis

Local time

Today, 03:52

Joined

Oct 22, 2004

Messages

1,187

• May 2, 2006

• #2

Do a search on cascading combo boxes..... or try this one
http://www.fontstuff.com/access/acctut10.htm
Sounds like what you are looking for.

 

B

bigbadbess24

Registered User.

Local time

Today, 04:52

Joined

Mar 9, 2006

Messages

83

• May 2, 2006

• #3

It sort of was but it is not really working for me.

 

B

bigbadbess24

Registered User.

Local time

Today, 04:52

Joined

Mar 9, 2006

Messages

83

• May 3, 2006

• #4

Anyone else have an idea. I would like to use a check box to check the grade level and a drop list for all of the school district and then be able to hit a command button "Enter" to run it.

 

ansentry

Access amateur

Local time

Today, 18:52

Joined

Jun 1, 2003

Messages

995

• May 3, 2006

• #5

I feel that you need;

Combo or List box to select the School District
Multi Select List box to select multiple grades

My reason for selecting from School Districts first is so that the grades list box would only display grades for the selected district.

Do a search on multi-select list boxes.