Combo Box autofilled by a form to update a table

  • Thread starter Thread starter BenAnd22
  • Start date Start date
B

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
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Datasheet combo box empty 1
Please help 31
Link a combo-box to another table 1
Simple form to update a table of dates 8
Table validation on junction table or form-level? 2
Normalization and splitting tables? 4
Combo box to show selective Records! 4
Lookup in a Form 6

Back
Top