Recent content by tomadom

Thanks very much. These are great.

Ok, I appologize. Was just losing my marbles over this small problem. I really do appreciate the help ;)

Honestly man.. you really haven't read the question have you :mad: Quiet clearly it's a bound control. That's the easy part! But now that this control displays a "looked up" value, and when that "looked up" value is changed in the combobox, how can I get that change in the "looked up" value...

Yes, agreed. But is there a way to change the value in a combobox and have it related to the ID number it is representing so that a change in the combobox results in a change in the record? Is there a way of changing the properties of the combobox to do this or do I have to write a macro to...

Thanks for the link. Will be very useful going forward.

Ok, I've used the wizard and I can now see the "looked up" values in my combobox. This leads me to a second question. Because I now have the looked up values in the combobox, the 'Row Source' property refers to Table2 for it's values. How do I make this combobox which is using the "looked...

It sounds like you are referring to the lookup table. I'm talking about trying to get this "looked up" value into a combobox on a userform. My combobox on my userform is still showing the value which was originally there before I did the lookup. Hence this part of my question..

The question you have referenced is about a lookup table. As I've tried to make clear, the lookup table part has been acheived. Now I'm trying to relate it to a form.

I have a table 'Table1' where 'Field 1' represents ID_Numbers. I wanted to see member_names in that column for reference so I did a lookup on that table using 'Table2'. 'Field1' in 'Table1' now displays member_names instead of ID_Numbers. I now want the looked up values displayed in...

These are just experimental tables I made up on the fly. I could have put anything there.

I just solved it. It was all a misconception. The table I'm doing the lookup in needs to have a common field with the lookup table. It's that common field in the table I'm doing the lookup in which is being replaced. It should have been obvious.

Sorry about that.. I'll provide more detail. Here are two tables. Table 1 and Table 2. Table 1: ID----field1----field2 1 -----one----- monday 2 -----two-----tuesday 3 -----three-----wednesday Table 2: ID-----field1 1 ------ january 2 ------february 3 ------march I want to do a lookup in...

I have created a lookup in an access table field which is based on the values in another table. My understanding is that the table I'm doing the lookup in is supposed to display the looked up value. In my case it hasn't. Would anyone know if there is a setting to make this happen?