im new to this site and i tried to look this up on the forums before i asked.
well here's the question.
I have a table (TestingDates) that contains the date and the start time for each subject. i have another table (TestSignup) where i would sign up people for the tests and this table uses two separate look up combo boxes one to select the testing date and another to select the time based on the (TestingDates) table. i built a form for the (TestSingup) table and i want the time field to automatically display the time based on the selected date from the Date. so lets say i pick 01/20/2012 on the date dropdown combo box the StartTime would automatically fill to 8:00 am
the (TestingDates) table is set up is this way
[PkDate][Writing][Math][Reading]
in each subject the time would be entered they are in medium time format
i also have queries made for each subject that display their particular times and dates but i don't know if these queries would be necessary
i am using access 2007 if it helps
is there anyway this can be done? Thanks
well here's the question.
I have a table (TestingDates) that contains the date and the start time for each subject. i have another table (TestSignup) where i would sign up people for the tests and this table uses two separate look up combo boxes one to select the testing date and another to select the time based on the (TestingDates) table. i built a form for the (TestSingup) table and i want the time field to automatically display the time based on the selected date from the Date. so lets say i pick 01/20/2012 on the date dropdown combo box the StartTime would automatically fill to 8:00 am
the (TestingDates) table is set up is this way
[PkDate][Writing][Math][Reading]
in each subject the time would be entered they are in medium time format
i also have queries made for each subject that display their particular times and dates but i don't know if these queries would be necessary
i am using access 2007 if it helps
is there anyway this can be done? Thanks
