filling in information using a combo box

[trackmedic]

Hi,

I have a form that has input points for a name, address, state, zip. I have made a combo box for the name that gets information from a table called vendors. How can I fill in the address, state and zip automatically when I choose a name in the combo box. Any help would be appreciated.

Thanks
Trackmedic

 

[David R]

http://www.access-programmers.co.uk/ubb/Forum2/HTML/001607.html

 

[trackmedic]

Thanks for the info, but, I'm still a little confused. I tried as your example stated but it still does not work. could you please explain it a little simpler. I'm sorta new at this.

trackmedic

 

[David R]

Your combo box will have something like 5 columns: An ID field, the VendorName, VendorAddress, VendorState, VendorZIP. You can make the first and last three zero-width so the user doesn't ever see them. Make sure you adjust the column count to 5, and the column widths to 0";2";0";0";0" (for example).

Then you add blank text boxes for Address, State, and ZIP. Set the Control Source to: =[ComboBoxName].Column(x) (probably x=3,4,5). Note that for some reason you have to leave the Me. part off, or it won't work. If the numbers don't give you the expected results I may be off by 1.

Now when you choose a value in your combo box, those fields will fill in with the 'hidden' values.

Hope that helps,
David R