I have an access database the is used to track project status. The part I am having trouble with is passing variables between forms. I have my project form and it has a subform that displays the tasks for the related project. The project ID would be C1 and the first task would be C1-1 the second would be C1-2 and so on. Right now what I am having trouble with is on the project for I have a buttob that opend the add task form so I can add a new task for the project. What I need to do is to count the records in the subform (which works) then pass the count to the add task form so I can automaticly assign the next task ID.
So the main problem I am having is passing the value created on one form to another. I was trying to use a public varaible but I cannot get the value to pass.
Any and all help would be appreciated.
