Hi all
I am using Access 2010 and need some help
I have a table called "Client" with client data
I have a table called "header" with order headers data
The "Header" table I have fields for Client data, such as name, address etc.
In my Orders form (which is based on the Header table) I need to give my users the option to
A: Fill the "Bill To" fields manually, or
B: Select an existing customer in a combo box and have Access fill the "Bill To" data for them
I do not need the "Bll To" data to be stored in the Client table, just in the Header table.
So i need the form to auto populate the "Bill To" fiels ONLY IF a recordfrom the Clinet table is selected with the combo box.
Can any of you provide the sample code ? I guess I would have to place this code in the AfterUpdate event of the combo box but I may very well be wrong
Many thanks for your patience!
I am using Access 2010 and need some help
I have a table called "Client" with client data
I have a table called "header" with order headers data
The "Header" table I have fields for Client data, such as name, address etc.
In my Orders form (which is based on the Header table) I need to give my users the option to
A: Fill the "Bill To" fields manually, or
B: Select an existing customer in a combo box and have Access fill the "Bill To" data for them
I do not need the "Bll To" data to be stored in the Client table, just in the Header table.
So i need the form to auto populate the "Bill To" fiels ONLY IF a recordfrom the Clinet table is selected with the combo box.
Can any of you provide the sample code ? I guess I would have to place this code in the AfterUpdate event of the combo box but I may very well be wrong
Many thanks for your patience!
