form not updating data

M

MLD

I have a dbase used to register and track attendance for training classes.
The main form is based on a parameter query for selecting a date, the date
and class offered on said date and code refering to the class show inthe
main form header, the subform displayes currently registered attendees.
Previosuly, the company I wrote it for only offered one class a day, so no
problem - when I added a person to be attending the class, it DATE of the
class (pulled from tblSchedule) would be included in the updated table
(ATTENDANCE), which records by employee number which people have registred
cor which class , canceled, attended, etc. Well now, I am in a new place
which offeres 2 or more classes a day. I finally go tthe forms to stop
showing a single registration in ALL classes on selected date, but when I go
to view the data in tblATTENDANCE, the date is no longer being recorded.

Any ideas? i apologize if I have not included specs needed, just let me knwo
what else is needed to troubleshoot this?
Thanks,
-Monica
(e-mail address removed)
 
G

Guest

Your table tblATTENDANCE should have these two fields to identify the date
and class:

Dated, Class

Your main form should ask the user to select/enter both fields and the
subform should be linked using the Master and Child Fields properties in the
subform Like:

Link Child Fields Dated;Class
Link Master Fields Dated;Class
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top