Display Query Information on a Form (Access 2007)

[Pam]

I have a form where a user enters contributions received from individuals.
The user chooses the individual from a combo box that lists all the
contributors (ContributorID, LastName, FirstName). When the user finds the
right contributor and selects it, I would like all the other information
about that contributor to be displayed down below on the same form ... only
showing their Address, City, State, etc. so that the user knows they have
chosen the correct contributor. Consequently, if they then continue and
choose another contributor down the list, the information at the bottom of
the form would change to reflect THAT contributor. I have tried creating a
query and putting it on the form, but I don't know how to link that with what
the user has selected from the combo box.

Any help would be greatly appreciated!

 

[Arvin Meyer [MVP]]

You can add the rest of the columns to the combo box, and, if you'd like,
set those columns to zero (0") width, Set the controlsource of the textboxes
below to refer to the columns, starting with column 0, like:

=cboContributorID.Column(3)

which is the 4th column

=cboContributorID.Column(4)

which is the 5th column

etc. Make sure you set the column count on the format tab to include the new
columns.

 

[Pam]

Arvin,

Thanks for the information. I have done that with a few of the columns
(LastName, FirstName, City). But for the person entering the data, I wanted
something more ... ummm ... VISIBLE ... to them when they select the
contributors name. Something that will show all the information to make sure
they are choosing the right one. I kind of have to make it VERY
mistake-proof for the person entering the data. That is why I wanted it to
show up in a separate spot on the form. Is there any way to do this?

 

[Arvin Meyer [MVP]]

Yes, as I mentioned add a textbox for each of the values that you want to
show. Set the controlsource of the textbox as I showed in my previous
answer. As you select the name, the other information will show in the
textboxes.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Pam]

Arvin,

Thanks! I misunderstood about the textboxes. It works!