|  | Combo Box autofilled by a form to update a table | | |
| | | BenAnd22 |  |
|  Posted: Wed Sep 17, 2008 4:39 am Post subject: Combo Box autofilled by a form to update a table |  |
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 | |
| | Posted: Wed Sep 17, 2008 5:27 am Post subject: RE: Combo Box autofilled by a form to update a table | |
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
--
Wayne
Manchester, England.
"BenAnd22" wrote:
| Quote: | 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 |
|
| |
| | | BenAnd22 | |
| | Posted: Wed Sep 17, 2008 10:33 pm Post subject: RE: Combo Box autofilled by a form to update a table | |
| |  | |
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
"Wayne-I-M" wrote:
| Quote: | 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
--
Wayne
Manchester, England.
"BenAnd22" wrote:
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 |
|
| |
|
|
