Auto-fill for text boxes

[Moe]

Hello Everyone,

(Background)
I created a database that will hold client information like business names,
address, and contact info. I've also created a form where users are entering
information whenever a call is received from that buisness which is stored in
another table. They have the power to select the buisness names from a combo
box which eliminates random calls being entered. What i would like to do is
whenever a buisness name is selected the address field is autopopulated from
the database, so that when they save the record on the forms table that
information is stored there as well. I've been reading some of the other
posts on this and i'm still a bit unsure. I have programmed before in C and
JAVA but not very famaliar in VB.

P.S. I'm using Micorosoft Access 2007

Thanks Again

 

[Jeff Boyce]

Nope (to be blunt), you don't!

You can provide a form that the user sees that displays the
person/address/other information, and allows for multiple call entries. The
standard way to handle this in Access is with a main form
(person/address/...) and a subform (calls pointing back at a person).

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Moe]

Ok, i would still like to know how to auto-populate information in a text box
when an item has been selected in a combo box in the same form. Please?

 

[Jeff Boyce]

Moe

OK, just wanted to be sure that you understood that storing data in two
places causes you more work.

If you want a form to display some related information (e.g., a person's
address), what about having a form that points to the table that has the
person (and the address)? The form would have controls that point to the
respective fields (from either the table directly, or via a query -
recommended).

Regards

Jeff Boyce
Microsoft Office/Access MVP