I am now working on a project management database. However, I got a question when selecting Milestone in Tasks Tab.
Please look into the attachments "Milestones.GIF" & "Tasks.GIF"
When a user create a project in project_details, afterwards, user required to fill in milestones. After finished Milestones, they should create some Tasks for each milestone.
However, as the database contains many projects, all milestones from projects are shown in Milestone combo box. How can I make using VBA to filter out the non-related Milestones?
The Milestones tab and Tasks Tab, all of it are datasheet. I don't know how I can make the [tasks].[milestone_id].RowSource = "....."
I tried it, but cannot work. Please help!!
Please look into the attachments "Milestones.GIF" & "Tasks.GIF"
When a user create a project in project_details, afterwards, user required to fill in milestones. After finished Milestones, they should create some Tasks for each milestone.
However, as the database contains many projects, all milestones from projects are shown in Milestone combo box. How can I make using VBA to filter out the non-related Milestones?
The Milestones tab and Tasks Tab, all of it are datasheet. I don't know how I can make the [tasks].[milestone_id].RowSource = "....."
I tried it, but cannot work. Please help!!
