Populating an underlying table when using cascading combo boxes in a form

[SandyUK]

Hello everyone

I have read the FAQ on cascading combo boxes and have managed to apply the theory to my DB's data input form (frmDataEntry) which is very cool and prevents a lot of errors however in doing so it no longer populates the underlying table (tblProductionDetails).

I am at a loss as to how to correct this as you can see from the example I need the customer and description field to be populated with the correct data rather than the fields I am using to make the cascading combo boxes work.

Any help would be greatly appreciated

Regards

Adrian

 

[MStef]

Hello Adrian!
Here it is. The field "Description" was UNBOUND.
I bound it. I added field "T31" on th form, and
some VBA. I think it is what you want.
(MStef alias Štef)

 

[MStef]

Or the better solution.

 

[SandyUK]

Stef

Thank you very much for the replies the examples you sent were great and I have learnt a new trick which is simple and very effective.

Hope life is treatng you well.

Regards

Adrian