ASAP Need data entry form fixed. Print Screen attached. done by SUNDAY 4/24/2011
For each unique date and location there are multiple lines of entry on a subform.
Mainform = Main Date
subform = data entry lines
The user can enter information for each date. When they choose a date from the drop down menu, the subform populates with the information for that date.
now the user needs to be able to choose and date and LOCATION, then have the subform populate the lines for that specific date and location.
at the moment the main form and subform are functional, its just the location sorting that needs to be added.
this is a SIGN IN SHEET. Choose date, then location, then signin.
YOU CANNOT MAKE A NEW FORM UNLESS YOU PLAN ON RE SCRIPTING ALL OF THE CASCADE BOXES AND EXPRESSIONS ON THE SUBFORM.
this needs to be worked into the existing form
tblEntryDates - holds all possible dates, unique, dates as PK
tblAttendanceLog - holds many dates, and corresponding fields of entry, ID as FK
tblLocations - Possible Locations, Locations as FK
Google talk, copy of database ready to rumble