Combo Box from table -- No Data just Headers

[lszuma]

I can't get my choices to display--only the Headers. In the selected field I choose combo box and choose the table to look up in the row source. The data columns are first in the table and their ID is last, but I only get the Header to display in the box. If I deselect header, I get an emply list

There are actually 7 columns in the look up table (the eighth is the ID) and 10 rows of possible choices.

Column Count: 7
Headers: Yes (or no doesn't matter)
Bound Column: 1 (changing doesn't matter)
Limit to List: No (so I can add)

What am I missing in the properties setting?

Also, can I use one of the columns in the look up table as a primary sort on a report? Or will it see the whole string of columns as one?

Thanks.

 

[Uncle Gizmo]

I would have thought that if you can see the headers, then if the data is available, you should be able to see the data.

I would suggest that you create another combo box exactly the same as the first and see if that works it may be that one of the settings was incorrectly set when you created the first combo box.

Is the combo box based directly on a table? Or is it based on a query?

 

[Pat Hartman]

When the combo list is expanded, you can see all the columns. When it is closed, you can see only the first visible column. When your combo contains more than one column, you can't add rows on the fly so use Limit to list so you can provide a popup form to enter the 7 columns.

 

[lszuma]

Thanks (again). I didn't realize that only the first columnt will ever display. When dropped down I can see all seven columns, luckily I have the most importate filed as the first column, which is fine, so long as I know the data is there.

Yes, the pop-up form on "Not on List" Event...I forgot about that nifty trick to quickly update the table.

 

[lszuma]

Choice is appearing in every Record

The selection that I choose from combox box list appears in every record.

 

[Pat Hartman]

The combo box is not bound. If you want a separate value for each row, you need to bind the control to a column in the underlying table.

 

[lszuma]

Already figured out the prorblem......

p.s,. I'm still working on that pop-up option to update. It's a combination of "on double click" and "not on List" but I'm missing something in the set up string....

I love to hate this program!

 

[Pat Hartman]

When you figure out your own answer it is only common courtesy to add a comment to that effect so the rest of us don't waste our time on your non-problem.

 

[lszuma]

I figured it out the next day. That's why I came back here to post.
Is there a way I can delete my own thread once the issue is resolved?

 

[Pat Hartman]

Deleting a thread removes it from the knowledge base so it won't help others searching for the same answer. If you find your own answer, just post what you figured out. This is one place where talking to yourself is allowed

 

[Uncle Gizmo]

This is one place where talking to yourself is allowed

Hehehe!

Never thought of it like that before! What happens if you start Arguing with yourself?

 

[Pat Hartman]

If you loose every one laughs at you.