I think have been able to do this in the past but am unable to at
present time. Have a form bound to a table. Have a combo box on the
form bound to a query. After selecting the item from the combo box
would like to be able to display some of the other fields from query in
text boxes on the original form that would be related to the record
selected from the query. When try to do this by using expression in the
text box control source referring to the query I get the famous #name?
error.
If someone could point me in the direction I need to go to solve
this would be greatly appreciated. My google searches have not been
much help at all. If need more info please advise.
Thanx
dc

On Mon, 22 Mar 2010 08:38:45 -0500, doncee
<nopsamdbc9814 (AT) nospamswbell (DOT) wanted> wrote:

Your combobox would have several (perhaps hidden) columns. The
ControlSource of those textboxes would be:
=myCombobox.Column(i)
(of course you replace myObjectNames with yours)

-Tom.
Microsoft Access MVP

Tom van Stiphout <tom7744.no.spam (AT) cox (DOT) net> wrote in
news:q20fq5tcigh6u29o61srgknlb0pen8ei2c (AT) 4ax (DOT) com:

Thank you.....thank you.......thank you again and again.
dc