Re: Combo Box problems

Tech-Archive recommends: Fix windows errors by optimizing your registry

if you have Lookup fields *in your tables*, i strongly recommend that you
get rid of them. see http://home.att.net/~california.db/tips.html#aTip8 for
more information.

also, i did look at the screen prints, and noticed that you set the
BoundColumn property to 0. the BoundColumn property value can only be set to
1 thru the total count of columns. example: three columns means a range of
possible values of 1, 2, or 3.

(note that attachments are frowned on in the newsgroups, so i don't mean to
encourage you to attach anything in future. if someone agrees to look at
your problem - via screen prints, or a copy of the db, etc, - that exchange
should be worked out between you and the other party, utilizing a website,
or email, or whatever.)

hth


"Mike" <reply@xxxxxxxxxxxxxx> wrote in message
news:T4ednQBSpsqpnbXZRVn-qw@xxxxxxxxxxxxxx
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
    ... the same value as another and have it display the correct item. ... isn't equal to the bound column. ... the price * Qty value and display it in this field. ...
    (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 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 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
    ... Sorry about the attachments they actually didn't come through on my news ... I had already done away with the lookup fields and ive changed the bound ... the same value as another and have it display the correct item. ...
    (microsoft.public.access.forms)