How is this form working?

[Lou_Reed]

I am confused about the workings of this db. The frmAttendance has a subform in it sfrmAttendance. When I select a Meeting date (upper left hand corner of frmAttendance) all personnel from tblPersonnel are shown. Now not all of their attributes are shown; just a space for whether they attended that meeting on that data or whether they were absent. Plus some notes if one wants to put them in.



Now once that criteria has been addressed the form can be clicked away and the data is recorded in tblAttendance. That is exactly what I want to happen. However, I cannot get my system to do the same. It just will not do that.

I have uploaded the db in the attached file. This is the working db. How are they doing this?

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[Lou_Reed]

I put the front end and the back end of the working db togtether for speed and ease of use.

The one that works is
Division_Dashboard.zip

The one that fails is

Division_Dashboard_1.zip.

I know now that a query is what is the record source for the Attendance form to get the info (from tblPersonnel) into sfrmAttendance.

I was able to glean that from the db that works. However, I still am not able to get all of the employees from
tblPersonnel into tblAttenddance's subform. It only loads one and I cannot understand why. Why not load all?

Any help appreciated. Thanks in advance.


Respectfully,

Lou Reed