Subforms date

G

Greg

I have a training class database. Under the class is a subform where the
students are listed. The date portion always wants to be the same for all
students but each student completes the class on different days. How do I get
the subform to recognize the different dates.
 
A

Al Camp

Greg,
Sounds like the date field in your subform is an "unbound" field. It should be a
"bound" field so that each record can have it's own date value.
In the table behind your subform, you should have a field like CompletionDate (Date
type). That field should be added to the query behind your subform, and the date field in
your subform should have a ControlSource of CompletionDate
 
Top