I have a form for entering Volunteer hours to collect statistics. The fields on the form are:
Act_Date The date picked from a control calendar
Volunteer A lookup field of volunteers name from the Volunteers table
Act_Activity What the time was slent on
Act_Hours The time spent
While working on one volunteer, there may be several entries and I want to automatically fill in the volunteer name field in use when a new record is chosen. Is there a way to do that?
Using Access 2002
Thanks,
Bill