Help with a lesson plan database please

DCMyers1

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

Subscribe Reply

1962

Allen Browne

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.c om> 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

DCMyers1

Many thanks - I will try it

David

Nov 13 '05 #3

Similar topics

328

Help with SQL query

by: Neil | last post by:

Hello I need some help with a SQL query (ASP page accessing Access database) I have a table called 'BookedRooms' which contains the following fields :- Room (text) DateBooked (date) Lesson (numeric from 1 to 9) Staff (text)

Microsoft Access / VBA

2388

Visual Basic class any help for learning VBA

by: Ann Scharpf via AccessMonster.com | last post by:

I am not sure which would be the best place to post this question, so I'm posing it here with Access general questions. I have reached the point many times in Word and in Access where my ignorance of VBA is a real detriment to me. I saw some posts about VBA classes with a particular vendor and the poster was advised not to take the class because of the likelihood of an unskilled trainer. My question is, would taking a Visual Basic...

Microsoft Access / VBA

2017

Easy for you, Difficult for me: Help a school

by: n | last post by:

Hello! Here is a problem I hope you can point me to a solution. It Problem: A teacher needs to know which lesson to teach. A school has a curriculum with 26 lessons, A-Z. For a given class, a random number of students arrive, each of which has completed a random number of lessons taken at random from the curriculum.

Microsoft Access / VBA

1550

please help in removing erroes in this c++ code

by: humsafar | last post by:

#include <iostream.h> #include <stdlib.h> #include <stdio.h> Class StudyProgram { Public: StudyProgram (); Void add StudyProgram (); Void edit StudyProgram (); Void delete StudyProgram ();

C / C++

8413

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8324

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8842

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8740

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8513

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

6176

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

2742

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1970

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1733

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General