Ok...Here's the situation. I have a subform that has 24 unbound text boxes in the Form Header that represent 24 months of a project. these boxes are filled in dynamically based on a Project Start Date and Project Finish Date. For each task of the project I also have a row of 24 unbound boxes. these boxes are to be filled with a monthly budget based on a calculation. My problem is I'm trying to set up some code that will look at the start and finish date of the task, and fill in the corresponding boxes with the budget based on the Header dates. I'm able to get it to look at the dates and compared them properly to fill in the correct number of months, however for every single task(which is a different record) the same number pops up in the same place....
Any suggestions would be most helpful
Thank you
Any suggestions would be most helpful
Thank you
