Auto Populate form text boxes based on value from combo box (1 Viewer)

[mlozano]

Hi

I have a form called frmPO based on a table called tblPO
One of the fields in tblPO is linked to the field idAddress in the table tblAddresses

The following fields exist in both tblAddresses and tblPO
Company
Address1
Address2
City
ZP
State

The form contains controls for these fields on tblPO. I would like to give the user the choice to either enter a shipping address manually, or selecting a preregistered address from tblAdresses. For this I would like a combo box showing the values of idAddress. I f a user selects a preregistered shipping address, I would like the form to fill the rest of the fields based on the value of this control.

My understanding is that I should set a BeforeUpdate event to set the values of the different controls, unfortunately my command of VBA amounts to 0. I would greatly appreciate any help you guys can provide

Many thanks, cheers

 

[pbaldy]

Is this what you're after?

http://www.baldyweb.com/Autofill.htm