Creating a form field which will populate the information automatically

[athanas-jifunze]

Hello team, I am new in access industry. I have developed a database for recording Teachers Trainings on Continuous Professional Development (CPD). I want to track the continuation of teachers attending the training (in a year each teacher need to attend three trainings to complete the module/course) In my form I have the field for appearance ( i.e. First, Second, Third, Fourth ...) I want these First, Second and so on to be populated automatically when a Participant/ Trainee is recorded. And when the Participant/Trainee come for the second time (Second) to be updated when I updated other fields.




Please I ask fro your help or guidance on this.


Thank you in advance

[AccessPower]

When you record the Trainee, is it always the same day they take the course? So if they're training today, would you input them today?

[athanas-jifunze]

No The training can happen today but the data get entered later, say a week after, and the second training happen after three months from the first one

[AccessPower]

So when you record a Trainee, do you input their instructor? If so, you can use vba on the AfterUpdate event where you would input the instructor. Have it loop through the instructor training fields (first, second, third, fourth) and find the first empty one. Then have it write the current date into that field. Or perhaps the training date for the trainee on the form.

[athanas-jifunze]

So when you record a Trainee, do you input their instructor? If so, you can use vba on the AfterUpdate event where you would input the instructor. Have it loop through the instructor training fields (first, second, third, fourth) and find the first empty one. Then have it write the current date into that field. Or perhaps the training date for the trainee on the form.

Sorry I am not clear when you say instructor you mean a Trainer? Can I share with the database so that you get a clear picture of what I mean, may be am not describing it correctly

Thank you in advance

[AccessPower]

Please feel free to zip your database and upload it here. People will have a better idea of what's going on.