Subforms date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

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

Similar Threads

Form for payments - Access 2003 3
Another query by combo box 1
How to finding student Rank and How to upload bulk marks of each student at a time. 1
Sort form records by field looked up in another table 1
differences betw subforms and linked forms creating many-to-many link 4
Runtime Error 2450 3
Tabular Form and VBA coding 1
Change subform based on textbox text 2

Back
Top