Combo Box autofilled by a form to update a table

[BenAnd22]

Hi All,
i am having troble with the following
I have a table called Clients and field called ClientID
I have a form called AddNewClient which generates the client ID
I have a subform called AddNewAddress which has the ClientID field auto
filled by the origanl form AddNewClient, This part all works fine !!
I want the ClientID field to also update into another table Addresses this
part doesn't work ???
I know this seems rather complex for an address however my clients can have
up to 15 addresses
Any help would be most appreciated

 

[Wayne-I-M]

You say you have a subform so best - simplest - method would be to create
another subform for the address's

This way the linking field (your ID) will auto fill for each new linked
address

 

[BenAnd22]

Hi Wayne

Thanks for your advice!!
Getting the ClientID to show on the subform is fine but it doesn't show back
in the Table. i have the same feild ClientID in 2 tables tblClients &
tblAddresses, from the subform i want it to update the ClientID in the Table
tblAdrresses all the other info updates when i save form but not the ID ???

Any thoughts

Cheers and thanks again
Ben