Hi,
I have a database that keeps track of schedules.
A user will select a week and will have his/her schedule for the week.
I am thinking of having a tab control and having 1 tab for every day of the week.
I have created a subform which has time,location,city, person, etc. I have used a subform because on any given day there may be multiple entries of events.
If I were to do it this way I would have to have the same subform on each tab control and then try and add 1 to the date on everytab.
Does anyone have any suggestions on if this would work? or suggestions on how I can do it differently?
My tables are as follows:
User
PK UserID
Username
Report
PK Date
PK Time
PK User ID
Location
City
blah
blah
Thank you for your help.
I have a database that keeps track of schedules.
A user will select a week and will have his/her schedule for the week.
I am thinking of having a tab control and having 1 tab for every day of the week.
I have created a subform which has time,location,city, person, etc. I have used a subform because on any given day there may be multiple entries of events.
If I were to do it this way I would have to have the same subform on each tab control and then try and add 1 to the date on everytab.
Does anyone have any suggestions on if this would work? or suggestions on how I can do it differently?
My tables are as follows:
User
PK UserID
Username
Report
PK Date
PK Time
PK User ID
Location
City
blah
blah
Thank you for your help.