Auto Populate Form (1 Viewer)

mlozano

Registered User.
Local time
Yesterday, 17:57
Joined
Sep 20, 2009
Messages
18
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!
 

Users who are viewing this thread

Top Bottom