Getting combobox/listbox data into a table

[Chad Cameron]

Hi All,

On my form, the user selects a company from a combobox. Then a listbox
populates with the contractors from that company. The user then selects 1
contractor and my subform populates with all the procedures that the
contractor has signed off. Everything works great (thanks to this
newsgroup).

Now, once I have the company & contractor selected. I see the procedures
he/she has and I want to add another procedure (as they are signed off).
When I do this, The CompanyID & the ContractorID are empty in my table, but
the procedure is listed. This makes sense, so...

I need to know how to get the CompanyID & the ContractorID from the Combobox
& Listbox and put them into the table. I am assuming I could have some
hidden textboxes, just wondering if there is a better way.

Thanks for everyone's help,
Chad

 

[Chad Cameron]

Sorry, my procedures are in the details section not a subform

 

[yvette estrada]

Hi All,

On my form, the user selects a company from a combobox. Then a listbox
populates with the contractors from that company. The user then selects 1
contractor and my subform populates with all the procedures that the
contractor has signed off. Everything works great (thanks to this
newsgroup).

Now, once I have the company & contractor selected. I see the procedures
he/she has and I want to add another procedure (as they are signed off).
When I do this, The CompanyID & the ContractorID are empty in my table,
but the procedure is listed. This makes sense, so...

I need to know how to get the CompanyID & the ContractorID from the
Combobox & Listbox and put them into the table. I am assuming I could
have some hidden textboxes, just wondering if there is a better way.

Thanks for everyone's help,
Chad