By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,462 Members | 799 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,462 IT Pros & Developers. It's quick & easy.

Help with a lesson plan database please

P: n/a
I am trying to create a database to store my lesson plans in and I have hit a
problem that I am sure is simple to solve but my lack of access (2000) ability
is getting in the way.

What I want to do is to have three combo? boxes on a form . The first two are
for subject (eg Biology & Human Biology) and the second is level (GCSE, AS &
A2).

What I want is for the contents of the third combo box to have a drop down list
of topic names controlled by the answers to combo boxes 1 & 2. How is it done
because I am sure it must be possible.

Any help very greatly received as I don't seem to be able to follow Access
manuals like I can Excel - Is it me or was the person who designed Access far
less end-user considerate that the one who designed Excel?

Thanks

David
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Use the AfterUpdate event of the first combo to set the RowSource of the
2nd.

Details in:
Limit content of combo/list boxes
at:
http://www.mvps.org/access/forms/frm0028.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"DCMyers1" <dc******@aol.com> wrote in message
news:20***************************@mb-m04.aol.com...
I am trying to create a database to store my lesson plans in and I have hit
a
problem that I am sure is simple to solve but my lack of access (2000)
ability
is getting in the way.

What I want to do is to have three combo? boxes on a form . The first two
are
for subject (eg Biology & Human Biology) and the second is level (GCSE,
AS &
A2).

What I want is for the contents of the third combo box to have a drop down
list
of topic names controlled by the answers to combo boxes 1 & 2. How is it
done
because I am sure it must be possible.

Any help very greatly received as I don't seem to be able to follow Access
manuals like I can Excel - Is it me or was the person who designed Access
far
less end-user considerate that the one who designed Excel?

Thanks

David

Nov 13 '05 #2

P: n/a
Many thanks - I will try it

David
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.