how can i use a combo box selection in a form to then autofill tex

[edwardcmorris]

What I would like to do is use a combo box on a form to then autofill other
text boxes on the same form.
I have a table containing Names, Numbers and Dog Names
I would like my form to have a combo box to select a Name, once the name is
selected I would like that to then autofill a text box for the Number and a
text box for the Dog Name.

I've never used access and am trying to teach myself so any help would bew
greatly appreciated.

 

[John W. Vinson]

What I would like to do is use a combo box on a form to then autofill other
text boxes on the same form.
I have a table containing Names, Numbers and Dog Names
I would like my form to have a combo box to select a Name, once the name is
selected I would like that to then autofill a text box for the Number and a
text box for the Dog Name.

I've never used access and am trying to teach myself so any help would bew
greatly appreciated.

Are you trying to *copy* the name and numbers from one table (the combo's row
source) into a different table (the Form's Recordsource)? If so... DON'T. That
information should be stored once, and once only, in the dog table.

To just *display* the name and number on the form you can include those fields
in the combo's row source query; make sure the Column Count property of the
combo is large enough to include them (you can set the ColumnWidths property
for the fields to 0 to hide them), and put textboxes on the form with control
source

=comboboxname.Column(n)

where n is the zero based index of the field in the combo. That is if the dog
name is in the 3rd column of the combo, use (2).