Combo Box In Table Not Showing On Form Field

[Guest]

I have a combo box that I created to link to a table that indicates a list of
reason for cancellation. The combo box is linked to a field in the table that
I have. The same field in the form is not showing a drop-down arrow to choose
from the list in the combo box. How or what do I need to do to get the field
in the form to have the same drop-down list that the same field in the table
has. I hope this makes sense and any help you can offer would be greatly
appreciated. Thanks in advance!

 

[gambit32]

In the properties of your combo box, what is your row source type and
row source?

 

[Guest]

Table/Query and Cancellation List Table

FYI - The table has 1 column with 13 rows (each row is a different reason
for cancellation).

 

[gambit32]

Try adding this to your Row Source properties instead of what's there
now:

SELECT TABLE NAME.FIELDNAME FROM TABLE NAME;

Substitute TABLE NAME and FIELDNAME with your data.

 

[ruralguy via AccessMonster.com]

Here's a link you may wish to read.
http://www.mvps.org/access/lookupfields.htm

 

[Guest]

I did enter that information that you recommended, but it still did not bring
up the drop down on the form in the field that I have it attached to in the
table. Any other suggestions?

 

[gambit32]

In the properties for your combo box, on the Data tab, what information
is where?

 

[Guest]

I am sorry, but I cannot find the Data tab that you are referring to. Is it
the properties of the table it links to or the Lookup of the table field it
is attaching to?

 

[gambit32]

What happens when you right click on your combo box and choose
properties? You should get a window with the following tabs: Format,
Data, Event, Other, All

 

[John Vinson]

This is one of the reasons that most serious developers dislike and
avoid the Table Lookup misfeature. See

http://www.mvps.org/access/lookupfields.htm

for a critique.

The table DOES NOT contain a combo box. It DOES NOT contain the looked
up data. Creating a Query or a Form based (directly) on the table
gives you the numeric ID field.

You can delete the control from your Form and create a new Combo Box
using the toolbox Combo control; have the magic wand icon selected and
let Access walk you through creating a combo based on your lookup
table.

John W. Vinson[MVP]

 

[pietlinden]

On Fri, 8 Sep 2006 13:15:02 -0700, HLD920

This is one of the reasons that most serious developers dislike and
avoid the Table Lookup misfeature. See

http://www.mvps.org/access/lookupfields.htm

for a critique.

I remember the first time somebody gave me a database to test me on.
The person designing the database used Lookups, which I never, ever
use. So it took me like a half hour to figure out why I was getting
really bizarre results for something that should have been so simple.

From then on, absolutely never. It defies the basic principle of "what

you see is what you get" by screwing with things under the covers.
Made me look really stupid. (Don't need anyone's help with that, I've
got it more than covered by myself!)

 

[J. Goddard]

This might be asking the obvious, bu are you sure you created a combo
box, and not a list box by mistake? I've done that.

John

 

[Guest]

Thank you very much for your help. What you offered helped me greatly. I was
trying to make the combo box to difficult to understand. Thanks for helping
me see that. I really appreciate your help and that of all of the MVPs.

 

[Guest]

I did create a combo box. I can see how it would be easy to create a list box
instead. I was able to find the answers that I needed.