List Box Displaying ID Numbers instead of text

On Thu, 10 Apr 2008 11:53:01 -0700, rkeefover
wrote:

Hey thanks for the tip, i HAD customized the code, not just copied it, but i
spelled one thing wrong which is why i was confused.

Well... you didn't SAY that... g

Sorry for snapping at you, but I can only go by what you post!

That got my list boxes
working correctly but if you wouldnt mind one last question, i am displaying
that information in text boxes at the point and since they are also drawing
information from the table that uses a lookup the text boxes are displaying
the numbers as well instead of text. Is there a way to fix that or should i
use something else to display the results?

Set the control source of the textbox to an expression looking in the actual
table where the information resides, or use a Combo Box based on that table
(bound to the numeric ID but displaying the text).

And... TURN OFF ALL YOUR LOOKUP FIELDS. As you can see, they are often far
more hassle than benefit!

And sorry it seems like i am just
using all ur ideas instead of creating it myself, but i actually did quite a
bit to set the rest of the thing up this is just some of the finishing
touches, as i said i am relatively new to this and not an expert as yourself
so i appreciate the help alot guys

You're welcome.... hope you can understand how hard it can be to know what you
have or haven't done, given the narrow bandwidth of the newsgroup medium!
--

John W. Vinson [MVP]