Complete form only once for an individual.

[CrostonScottish]

I have a form listing all students in an Access 2003 database. One control button [Initial Assessment] next to each students name has a macro which opens a new form designed specifically for the initial assessment. It also sets values in the new form, taking the Students ID, Forename, Surname, Course from the previous form listing all students. This was to reduce the re-typing of the same data.

As initial assessments are only intended to be done once. Is there some way i can alter my macro or add something to ensure that each student can only have one initial assessment done as it would only be when running the report that you find out if the student has had their initial assessment entered more than once.? The data for the initial assessment is stored in a table [tblinitass]

Any help would make life easier.

Croston Scottish

[nico5038]

I have a form listing all students in an Access 2003 database. One control button [Initial Assessment] next to each students name has a macro which opens a new form designed specifically for the initial assessment. It also sets values in the new form, taking the Students ID, Forename, Surname, Course from the previous form listing all students. This was to reduce the re-typing of the same data.

As initial assessments are only intended to be done once. Is there some way i can alter my macro or add something to ensure that each student can only have one initial assessment done as it would only be when running the report that you find out if the student has had their initial assessment entered more than once.? The data for the initial assessment is stored in a table [tblinitass]

Any help would make life easier.

Croston Scottish

Hi Croston,

Basically it's against the normalization rules to "move" the Student ForeName, SurName, etc. to a new entry in a [tblinitass]. When you need them, just join the table by the StudentID to extract the needed fields.
For inserting the initial assessment there are also multiple solutions.
I assume there will be more than one assignment and that the assignment data will be rather "similar". Thus a tblAssessments could be used and when defining a Student, the first entry can be inserted automatically when needed.
Personally I would create a Student form with the Assessments as a subform. When the subform is linked, then Access will synchronize the Assessments and fill the StudentID automatically for new entries.

Getting the idea ?

Nic;o)

[CrostonScottish]

Cheers. I had a feeling that if i couldn't find a way through the macro then it was probably my bad initial design. Back to the drawing board!

Thanks again

[nico5038]

Perhaps my "Object/Action" sample gives a nice template for solving your design problem:

http://www.geocities.com/nico5038/xSample-Datasheet-Filter-ObjectAction-97.zip

I use it often as a start and give my users also an instruction how to filter and sort:

http://www.geocities.com/nico5038/xRightClickInstruction.zip

Keep me posted !

Nic;o)