Joshua61679
Technical User
Hi all.
I've been pulling my hair out on this one. I've got a form of jobs that we do. On the formthere is some extrainious job info, there is a job number, that is based on an autonumber, and there is a combo box that has a list of the crew members that are assigned to that job. This is how that list is formed:
1.On the job form, click on comand button "Assign Crew"
2.Crew members form based on crew members table opens
3.When you dbl click on a crew members name a macro runs
4.The macro then places the name, and the job number of the current record into a form
5.That crew form is based on a table, so the values are stored.
6.On the job form, the crew combo box is set to run a query onEnter7.The query selects the names that are associated with the job number of the current record.
This all works fine, but I have yet to figure out how to this list of crew members to show up on a report with the rest of the job info. Any ideas?
I've been pulling my hair out on this one. I've got a form of jobs that we do. On the formthere is some extrainious job info, there is a job number, that is based on an autonumber, and there is a combo box that has a list of the crew members that are assigned to that job. This is how that list is formed:
1.On the job form, click on comand button "Assign Crew"
2.Crew members form based on crew members table opens
3.When you dbl click on a crew members name a macro runs
4.The macro then places the name, and the job number of the current record into a form
5.That crew form is based on a table, so the values are stored.
6.On the job form, the crew combo box is set to run a query onEnter7.The query selects the names that are associated with the job number of the current record.
This all works fine, but I have yet to figure out how to this list of crew members to show up on a report with the rest of the job info. Any ideas?
