So I have a subform that shows directly on my main form. Dependin on which route i select in a seperate combo box, that specific route information shows up in this sub form (route#/Scheduled Time). I want to add some extra columns to this subform so that, for example, if a route is running behind, i can update that route with new times....but i still want the scheduled data to show, so i'll need to do it in another column.
BAsically i wanna be able to do the folowing:
1. select a route in the combo box (already done)
2. have the scheduled data show up in the sub form. Howver, i dont want this data to be editable. (already done)
3. update with new times due to the delays. - this is the part i cant figure out. I need some blank colums that are editable to show up on the subform so i can update with the new time.......however, i dont want the scheduled data to be editable.
final subform would look something like this:
Route#/Scheduled/Actual Time
BBAA2/12:30 P.M./4:30 P.M.
The "Actual Time" Column is the only one that i want people to be able to edit.
BAsically i wanna be able to do the folowing:
1. select a route in the combo box (already done)
2. have the scheduled data show up in the sub form. Howver, i dont want this data to be editable. (already done)
3. update with new times due to the delays. - this is the part i cant figure out. I need some blank colums that are editable to show up on the subform so i can update with the new time.......however, i dont want the scheduled data to be editable.
final subform would look something like this:
Route#/Scheduled/Actual Time
BBAA2/12:30 P.M./4:30 P.M.
The "Actual Time" Column is the only one that i want people to be able to edit.