Form and subform relations tricky

[User25]

Just a guy who wants to learn...



My goal is to update Attendace table easier by having a form where i could choose a team from a combobox and based on that value in a subform to have all the employees names associated with that team displayed one under another with DateAttendance, Hours, Minutes fields blank (from Attendance table) so i can input relevant data daily for all in the same time by pressing a Save button in that subform.
The association between employees names and teams is done in the query called ActiveEmployees that takes its data from Employee table where i removed the ones who have an end date associated to their names, which means that they no longer work with us.
Any help will be appreciated!!!

I attached the draft! Thank you!

[June7]

Would need to create records for that team for that date. This is 'batch' creating records. An SQL INSERT SELECT can do that. Something like:

CurrentDb.Execute "INSERT INTO Attendance(EmpID, DateAttendance) SELECT EmpID, Date() FROM Employees WHERE Active AND TeamID=" & Me.TeamID

Then requery subform so these new records will display.

Suggestion without viewing db as I cannot download now.

[moke123]

I think I may have read your requirements wrong but here's an example anyway.

Your tables need some normalization so I didn't use them. I also used list boxes instead of a combo.

This may at least give you some ideas.

[User25]

Thank you. It really helped.