Hello,
I am building a Construction Dispatch Program. In it I have a Main Form, that has 2 drop down combo boxes to pick Customer and Job. It also has a drop down box for drivers. When I pick one of each and hit add, it adds the Customer and Job to a sub form, and shows the driver under that project. Now I can also add additional truck drivers to that job, as long as I have the Customer and Job entered in the main form. Works grate.
I have the Subform running continuously and can have a ton of different jobs running in the sub form.
My problem is this: I want to add a driver to say the fifth job in the list. But I have to have the Customer and Job number in the main form, but it is set to my last driver addition, which could now be the 20 job I have entered. So if I could say highlight the fifth job, and have it populate the main forms Job and Customer info, I could then add a driver to that Job without having to pick the info again from the drop downs.
I hope that makes sense. I have tried to tackle this for hours.
Thanks a ton,
Troy
I am building a Construction Dispatch Program. In it I have a Main Form, that has 2 drop down combo boxes to pick Customer and Job. It also has a drop down box for drivers. When I pick one of each and hit add, it adds the Customer and Job to a sub form, and shows the driver under that project. Now I can also add additional truck drivers to that job, as long as I have the Customer and Job entered in the main form. Works grate.
I have the Subform running continuously and can have a ton of different jobs running in the sub form.
My problem is this: I want to add a driver to say the fifth job in the list. But I have to have the Customer and Job number in the main form, but it is set to my last driver addition, which could now be the 20 job I have entered. So if I could say highlight the fifth job, and have it populate the main forms Job and Customer info, I could then add a driver to that Job without having to pick the info again from the drop downs.
I hope that makes sense. I have tried to tackle this for hours.
Thanks a ton,
Troy