Combo Box problems

[Mike]

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.

 

[tina]

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]

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

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

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.

 

[tina]

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

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

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

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.

 

[Mike]

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

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

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

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


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.

 

[tina]

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

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

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

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

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


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.

 

[Mike]

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.

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

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

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


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

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


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.

 

[Mike]

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

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.

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

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

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


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

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


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.

 

[tina]

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

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

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.

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


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

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


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

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


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.

 

[Mike]

Sorry about the attachments they actually didn't come through on my news
server.
I had already done away with the lookup fields and ive changed the bound
column value to 1 2 and 3 and i still end up with all the records having the
same entry.
Wow this is extremely frustrating. Can you recommend a forum for access
users or would you happen to have any other ideas on what could be causing
this?

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

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

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.

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


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

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


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

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


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.

 

[Mike]

Well sometimes its the simple things that trip you up.
Turns out the problem was that when i added the new combo box that its
control source field was empty.
Anytime i tried entering something i would get an error message when
selecting from the list.
I had to put insert a new column in the table that the rest of the form
stores its records in and now it works.
Makes sense that the table the combo box was getting its data from couldn't
be used for storing the selected entries.
Step away from playing with Access for a few years and the rust begins to
form...
Thanks Tina for your help. Never easy dealing with us newbie's.

Mike

Sorry about the attachments they actually didn't come through on my news
server.
I had already done away with the lookup fields and ive changed the bound
column value to 1 2 and 3 and i still end up with all the records having
the same entry.
Wow this is extremely frustrating. Can you recommend a forum for access
users or would you happen to have any other ideas on what could be causing
this?

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

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

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.

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


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

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


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

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


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.

 

[tina]

hey, you got it figured out, good job! good luck with the rest of your
project, and you're welcome.

Well sometimes its the simple things that trip you up.
Turns out the problem was that when i added the new combo box that its
control source field was empty.
Anytime i tried entering something i would get an error message when
selecting from the list.
I had to put insert a new column in the table that the rest of the form
stores its records in and now it works.
Makes sense that the table the combo box was getting its data from couldn't
be used for storing the selected entries.
Step away from playing with Access for a few years and the rust begins to
form...
Thanks Tina for your help. Never easy dealing with us newbie's.

Mike

Sorry about the attachments they actually didn't come through on my news
server.
I had already done away with the lookup fields and ive changed the bound
column value to 1 2 and 3 and i still end up with all the records having
the same entry.
Wow this is extremely frustrating. Can you recommend a forum for access
users or would you happen to have any other ideas on what could be causing
this?

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


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

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.

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


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

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


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

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


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.