Linking fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am new to access and I am trying to get multiple text boxes to automaticly
fill in when using a combo box like in the Northwind sample database.
Example; entering a company name and having the address and ship to address
automaticly fill in. Can anyone help with this please?

Scott
 
To show the additional address fields:
-make sure the values are in the combo box row source
-set the control source of an unbound text box to something like:
=cboAddressID.Column(1)
Column(1) is actually the second column in the combo box row source.

This solution suggests you are not storing the related fields in another
table.
 
Thank you Duane, I will give this a try.

Duane Hookom said:
To show the additional address fields:
-make sure the values are in the combo box row source
-set the control source of an unbound text box to something like:
=cboAddressID.Column(1)
Column(1) is actually the second column in the combo box row source.

This solution suggests you are not storing the related fields in another
table.
Click to expand...
 
Duane: how do I actually set the control source. I just looked in the
properties and wonder how I set the path making sure I use the correct info.
 
The control source is a property of most controls such as text boxes, list
boxes, and combo boxes.

I don't know what you mean by "set the path".
 
Duane, I understand how to set up the combo box and choose the fields I want
to show when I do a look up but I still am not sure how to make those other
fields/colums show in other text boxes. I tried one and made it work but
then could not get another to work. Can you explain from step one how to
connect the text box to the combo box?
 
Set the Row Source property of your combo box to include the additional
fields you want to display in your text boxes. Then set the control sources
of the text boxes like:
=cboYourComboBox.Column(x)
where x is the number of the column that you want to display (zero-based)
 
Back
Top