Re: Combo Box problems

Could these issues be due to the lookup fields being populated for
Disposable Goods in the table of the same name?

"Mike" <reply@xxxxxxxxxxxxxx> wrote in message
news:BvCdnWGnJtRkUbrZRVn-vQ@xxxxxxxxxxxxxx
Ok one problem solved. I am now able to select an item in the list with
the same value as another and have it display the correct item.

It still keeps which ever item i select in the combo box for each record.
If i try to leave the field blank i get "The text you entered isn't an
item in the list" if i try to set Limit to List to No, it tells me that
"The first visible column, which is determined by the ColumnWidths
property, isn't equal to the bound column. Adjust the ColumnWidths
property first, and then set the LimitToList property"
So i go and set the Column Widths to 1";1";1" and it still gives me the
same error when trying to set the LimitToList to No.

"tina" <nospam@xxxxxxxxxxx> wrote in message
news:C5LVf.32479$bn3.15076@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
presumably the ID field is the table's primary key. if so, then either
put
it as the first column (you can set its' column width to zero (0) so that
it
doesn't show in the droplist), or change the BoundColumn to 3.
personally, i
always put the bound column as the first column, but if binding the third
column works for you then i don't know of any reason to not do that.

hth


"Mike" <reply@xxxxxxxxxxxxxx> wrote in message
news:HpydnRKdLLg1qrrZnZ2dnUVZ_umdnZ2d@xxxxxxxxxxxxxx
Tina,
Yes on both here is the Row Source control:
SELECT [Disposable Goods].[Disposable Goods], [Disposable
Goods].[Disposal
Charge], [Disposable Goods].ID FROM [Disposable Goods];
Im going bald so i cant afford losing any more hair any suggestions
would
be
greatly appreciated ;)

Mike

"tina" <nospam@xxxxxxxxxxx> wrote in message
news:PrGVf.31768$bn3.29975@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
is the RowSource of the combo box supplied by a table? if so, does the
table
have a primary key? if it doesn't, it should.

hth


"Mike" <reply@xxxxxxxxxxxxxx> wrote in message
news:VcednTnLA-TobrvZRVn-tw@xxxxxxxxxxxxxx
Thanks Tina,
I had it worked out another way but i like your expression better.
I still have an issue now where if any of the item costs are the
same,
then
when i select an item in the combo box of the same value it will
always
display the first item name in the list and not that of the selected
item.
I
changed all the item values to different values and it works but i
need
to
find a fix for that.
The other major problem is that all records end up with the same
entry
in
the combo box.
I had to leave the bound column value at 2 or i would get an error.
Id be happy to email you a copy if you have the time.

Thanks

"tina" <nospam@xxxxxxxxxxx> wrote in message
news:seCVf.630975$qk4.546091@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
change your BoundColumn back to 1. change the expression in the
calculated
control to

=[Combo62].[Column](1)*[Text56]

note that the combo box column index is zero-based, so the first
column
(from left to right) is zero (0), the second column is 1, the third
column
is 2, etc.

hth


"Mike" <reply@xxxxxxxxxxxxxx> wrote in message
news:NeednX64nv5wMrvZRVn-sg@xxxxxxxxxxxxxx
I have a combo box that im using to display 2 values from a table.
When clicking on the down arrow of the combo box im displaying the
item
description in the left column and the corresponding price in the
right.
I then have a text box next to this field called "Qty." where im
entering
in
the qty of items.
I then have a third text box called "Charge" that i want to have
calculate
the price * Qty value and display it in this field.
Im having a heck of a time getting this to work properly.
It somewhat works with the following as the control source for the
"Charge"
text box: =[Combo62]*[Text56].
I have to set the Bound Column value for the combo box to 2, but
here
is
the
problem. If any of the values are the same for the price the text
doesn't
change when a new item with the same price is selected.
I have changed all of the values so they were different and it
works
great.
Unfortunaly a lot of the items have the same value so i need to
make
this
work.
Im sure there is a way to do this and probably an easy one at
that.
Any help would be appreciated.
















.

Relevant Pages

  • Re: Combo Box problems
    ... if you have Lookup fields *in your tables*, ... the same value as another and have it display the correct item. ... isn't equal to the bound column. ...
    (microsoft.public.access.forms)
  • Re: Combo Box problems
    ... control source field was empty. ... the same value as another and have it display the correct item. ... isn't equal to the bound column. ...
    (microsoft.public.access.forms)
  • Re: Combo Box BoundColumn property
    ... HTH, ... Is it possible to display both columns yet return the contents of Column B ... Bound Column: 1 ... how can I set the BoundColumn property of the list so ...
    (microsoft.public.access.forms)
  • Re: Combo Box problems
    ... BoundColumn property to 0. ... the same value as another and have it display the correct item. ... isn't equal to the bound column. ...
    (microsoft.public.access.forms)
  • Re: Combo Box problems
    ... Yes on both here is the Row Source control: ... I had to leave the bound column value at 2 or i would get an error. ... the price * Qty value and display it in this field. ...
    (microsoft.public.access.forms)