How to create a schedule from a form

[boanet]

I am trying to produce a scheduling form and having trouble figuring out how to approach it. Any advice would be great. Basically I created a form showing a list of tasks that need to be completed. In the header section I put a series of unbound text boxes 8-12 total showing the next 8-12 Friday weekending dates. In the detail section under the corresponding week ending the user would enter the hours budgeted for that week. An individual task may take multiple weeks.

I need to somehow store the weekending from the unbound header and the hours associated with the task.

Task Total Hours 10/17/08 10/24/08 10/31/08 11/7/08

Task 1 8 2 6
Task 2 20 5 5 5 5


Store in table somehow

Task Weekending hours
Task 1 10/17/08 2
Task 1 10/24/08 6
Task 2 10/17/08 5
Task 2 10/24/08 5
Task 2 10/31/08 5
Task 2 11/7/08 5

[Kevin Wilcox]

Hi

It sounds like you could use a separate table to capture the data; which would have the taskID, the hours, and the w/ending date. I'd also have things like the updated date and userID. I think I'd capture this by having the user click a 'save' button on the record (presumably a continuous form?), and on the 'onclick' event for this, append the taskID, hours and wending to that table. I'd get the w/ending value by cross-referencing the input box to the relevant unbound w/ending box, i.e. something like

if not isnull(me.inputbox1) then
'append w/endingbox1.value, taskID,hours, user, Date() to my table (but coded appropriately)
end if

.... and so on for each input box.

and I'd force the user to save by using a msgbox when they try to leave the record without saving. you could of course have the append take place automatically through code as they leave the record but I'd not want them hopping in and out, creating multiple records for each week when they change their mind - so I'd also look at including edit and delete buttons/facilities, which would return the current record from this "tblHours".

Kevin