Continuous Form create Yes/No Option

[JustMargie]

All of the training completed by our 130 employees must be tracked and I am responsible for being able to report the training statistics by employee, date of completion, category.... etc..

The AVP has now requested that each group spend 30 minutes training their staff per week and to make it easy on the supervisor, they can do this in increments as little as 10 minutes per session.

Yeah, you guessed it. Tracking nightmare.

I have a continuous form for each group of employees (there are 3 shifts). I have been trying to create a split form with the master form containing: Date of Training, Instructor, Topic, Duration. That's very simple. But, I would like a sub-form with either a data sheet form or a continuous form listing the employees on each shift with a yes/no field for attendance. Is this possible and how? BTW, the table of completed training contains a Yes/No field.

I would like to add a check box and use an AfterUpdate event procedure which will put a "yes" (0) in Table "Completed Training" in the field "Completed" . Unfortunately, I don't know how to write this code.

 

[SmallTime]

Sounds like you already have this cracked.

Just make a continuous form with the Records Source based on the table of completed training. You already have a Yes/No field in the table which will become the control source for an object on your new form. whether you use, a check box or combo box, doesn't really matter so long as the objects control source is the same as the Yes/No field in the table.

Then drop the new continuous from into you main form and make sure the two are linked appropriately.

(I've assumed you have two RELATED tables, one for employees and one for Training)

SmallTime

 

[JustMargie]

Thanks SmallTime,
("Sounds like you already have this cracked.")

One would think so, but apparently I have done something wrong. Either in the relationship between the tables, the yes/no field on the table or the yes/no field on the form. Grrrrrrr. When I check one box it automatically fills ALL of them.

It's driving me berserk

 

[boblarson]

If all checkboxes get checked when you check one, one of a couple of things is happening. The first is that you have an unbound checkbox. An unbound checkbox on a continuous form or datasheet is really only one checkbox and it LOOKS like it is multiples (one for each record) but that is just the illusion that Access casts. So, if you have a continuous form or datasheet you need to have a field you can bind the checkbox to so you can make the change for a single record.

The other possibility is that the After Update code is calling a SQL statement that updates more than the individual record. But again, the checkbox needs to be bound so that it will display discretely the value of that one record.