How to connect textbox to a query

[alextol]

I have a form with the texbox, combobox and RunReport command button. I also have a query: ClientInfo. I want to enter client ID into Combobox, click Run Report button and have my textbox populated with the Client's Name. How do I connect textbox to a query and Run Report button? Can someone please help?

[pbaldy]

This would be more efficient:

http://www.baldyweb.com/Autofill.htm

your way would require a DLookup() or opening a recordset.

[alextol]

1) If I used your way, how do I connect Combo box to the query? I tried opening (and typing in name of the query) in Combo box control source field. It didn't work. Its not availible in the drop down menu.

2) If I used DLookup () method, where would I type in the DLookup formula? in the Event or Data Property section? and which line?

[pbaldy]

The query would probably be the row source of the combo. The DLookup() could be the control source of the textbox.

[alextol]

Thanks Paul. I made it work your way, but for some reason two of my text boxes (they pull data from columns 9 and 10 in the query are not working. Is there a limit on how many textboxes one can outfill this way?

[pbaldy]

The "usual suspect" is the column count property of the combo not being set correctly.

[alextol]

Thanks pbaldy! This was it. It works now!

[pbaldy]

Happy to help!