Quicker than DLookup

[rube]

I know there has to be a better way.

I use combo boxes frequently whose 0 width, bound columns are integers. When I want to diplay the results (associated text) in a list type format, using a text box, I know I can display the results in a combo box, make my control 0 width, and the it will produce the results I want, except for the fact it is a combo box with the drop down, and the user thinks they can change this.

Or I use a text box with a Dlookup, which works fine but is slow. I can also hide the original combo box, and copy the results to a text box. This seems like a lot of work for the result. Is there a simpler/quicker way?

I have searched the posts, but not found anything on this topic in particular.

Thanks for any input,

Rube

 

[Mile-O]

DAO or ADO, depending on your version.

 

[dcx693]

Do you mean something like this? Question about combo box data into text boxes.

 

[rube]

Thanks

dcx693, that worked, thanks.

txtBox

=[cboBox].[Column](1)

Would you mind showing the difference M-O-P, or is this way (adding the text box w/source, hiding the combo going to be the quickest?)

Thanks again,

Rube