Joshua61679
Technical User
I've been pulling my hair out on this one. I've got a form of jobs that we do. On the form there 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 get this list of crew members to show up on a report with the rest of the job info. Maybe I need to find another way to create the list. Any ideas?
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 get this list of crew members to show up on a report with the rest of the job info. Maybe I need to find another way to create the list. Any ideas?
