one form for different class with different subjects

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

Follow Post Reply

1641

MMcCarthy

14,534

Expert Mod 8TB

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

Expand|Select|Wrap|Line Numbers

 
Table Name=tblStudent
  StudentID; Autonumber; PK

Family; String; FK

Name; String

University; String; FK

MaxMark; Numeric

MinMark; Numeric

What tables/queries are the forms currently based on?

Mary

Feb 23 '07 #2

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

NeoPa

32,301

Expert Mod 16PB

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

Post your reply

one form for different class with different subjects

Post your reply

Similar topics