Combo Box Problems

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

I have a form with a combo box on it. The combo box gets
its list from a table set up with item names and prices.
The problem is, some of the items on the list will not
select while most of the others do. I don't get any error
messages, the item just won't select and another item
endes up on my form. Any ideas???
 
Is the combo box bound to the primary key field in the underlying table? Are
you trying to select a value that already exists in the table in that field?
When you try to select one that won't select, what does the Status bar
(bottom of ACCESS screen) show as a message?
 
Joe

If your combo box uses a query from a table, perhaps there's something about
the query that doesn't allow selecting of all items in the table?

I'm not clear on what you mean when you say "and another item ends up on my
form".

Please post the SQL statement for your combo box's source.
 
The combo box is not bound to the primary key field. It
is bound to one of the colums which happens to be price.
The problem occures when there are several items with the
same price. It will only select the first item. When
you try to select one of the others it enters the first
occurance of that price in the table.

Thanks for the help.
 
Thanks Jeff,
I have determined that the problem occures when there is
more than 1 item on the list with the same price. In
that case, I can only select the first occurance of that
price. Any other selection results in the first
occurance being entered. I hope this clears this up a
little.
 
Not sure of your description but another thing to watch out for is that the
ComboBox RowSource can only have max 64K rows. If you have more than 64K
rows in the RowSource (and 64K rows is simply too many for the users to
select one from), you need to do some sort of pre-filtering to reduce the
number of rows.
 
Joe said:
The combo box is not bound to the primary key field. It
is bound to one of the colums which happens to be price.
The problem occures when there are several items with the
same price. It will only select the first item. When
you try to select one of the others it enters the first
occurance of that price in the table.
Click to expand...

I assume you select the item which has a price rather than selecting a price
and then deciding on the item.

The bound field should be the ID of the item.
The rest of the information should be filled in from the item table with a
query joining the InvoiceItem table or what ever you call it.
 
The combo box is not bound to the key field. I am
selecting descriptive items from a table of prices and
passing the item description and the price to the table
the form is bound to. The message across the bottom just
says calculating...and then enters the first item with
that particular price.
 
OK Jeff, Here it is.

SELECT tblLaundryPrices.ProductsID,
tblLaundryPrices.Item, tblLaundryPrices.PricePer,
tblLaundryPrices.Cost
FROM tblLaundryPrices;

This is a really simple form. I just can't figure out
what the relation is between the prices and makes access
refuse to recognize anything other than the first
occurance of that price even though it comes up in the
combo box. By the way, the same thing happens if you use
the table ruther than a query as the row source. Thanks
for your help.

Joe
 
OK, now how 'bout what settings you have for the combo box's properties
concerning bound column, column width, etc. I'm trying to get a "picture"
of what the combo box is doing with the row source provided by this query.
 
Back
Top