one form for different class with different subjects

shivak

Hi

I have designed a MS Access database for progress report(grade) for students in a school.
We have different classes with different subjects.
Now I am using different forms for each section for input data.
I want to use a single form, when opened ,according to section the subject fields should change to receive the input.

Is it possible?

Pleeeeeaaaaaaaaaaase help me!

[email removed]

Feb 23 '07 #1

MMcCarthy

At a guess I would say it is possible but you will have to provide a lot more information. Give the metadata for the relevant tables.
Posting Table/Dataset MetaData

shivak

Hi
Thanks for caring

I have a table1 for students details

Student ID
Name
Class
Section
Etc

Another table2 for marks

EnglishMarks
PhysicsMarks
ChemistryMarks
BioMarks
CompSc.Marks
EnggDrwg.Marks

In the main form if user selects section A;

The input form should contain only
EnglishMarks
PhysicsMarks
ChemistryMarks
In the main form if user selects section B;
EnglishMarks
BioMarks
CompSc.Marks
And so on for other class.

That means every section has fixed and allotted subjects.

Now I have manually designed forms and reports for each sections, instead I am trying to find can I do with queries or other techniques.

Thanks in anticipation.
shiva

Feb 23 '07 #3

MMcCarthy

Is StudentID also in the marks table?

Feb 23 '07 #4

shivak

yes, there is student ID

Feb 24 '07 #5

NeoPa

To handle options like these you can include all the fields that are ever required, then, using the .Visible property of the controls on the form, you can select which ones show in any particular circumstances.
The OnCurrent event procedure should be where you place the code which will determine which controls should be shown under which circumstances.

Feb 26 '07 #6