Combo boxes

[TK]

I have a combo box on one form with has a row source of
2 fields, an item number and item name.

I item number width is 0 so it only displays the name, I
have another text box that displays the number from the
combo box.

On the other form I want to get the item name from the
combo box but I keep getting the number. How would I do
this? I Even tried SQL statements to select the item
from the item table where the item number from the
original form matched the item number in the table but
couldn't get that to work either.

SQL used: txtName = "SELECT tblItems.ItemName FROM
tblItems WHERE tblItems.ItemNumber = txtItemNumber"

[Milan]

To refer to a combobox column you can use Column(i)
property. First column is always index 0, second 1, etc.
For example if combobox name is ItemNumber and it has two
fields second being item name then you can refer to the
item name value as ItemNumber.Column(1). It doesn't matter
whcih column is visible. The order will match the order of
fields in the combobox query/sql statement.

Milan

>-----Original Message-----
>I have a combo box on one form with has a row source of
>2 fields, an item number and item name.
>
>I item number width is 0 so it only displays the name, I
>have another text box that displays the number from the
>combo box.
>
>On the other form I want to get the item name from the
>combo box but I keep getting the number. How would I do
>this? I Even tried SQL statements to select the item
>from the item table where the item number from the
>original form matched the item number in the table but
>couldn't get that to work either.
>
>SQL used: txtName = "SELECT tblItems.ItemName FROM
>tblItems WHERE tblItems.ItemNumber = txtItemNumber"
>.
>

[TK]

That worked perfect. Thank you

>-----Original Message-----
>To refer to a combobox column you can use Column(i)
>property. First column is always index 0, second 1, etc.
>For example if combobox name is ItemNumber and it has

two

>fields second being item name then you can refer to the
>item name value as ItemNumber.Column(1). It doesn't

matter

>whcih column is visible. The order will match the order

of

>fields in the combobox query/sql statement.
>
>Milan
>

>>-----Original Message-----
>>I have a combo box on one form with has a row source

of

>>2 fields, an item number and item name.
>>
>>I item number width is 0 so it only displays the name,

I

>>have another text box that displays the number from the
>>combo box.
>>
>>On the other form I want to get the item name from the
>>combo box but I keep getting the number. How would I

do

>>this? I Even tried SQL statements to select the item
>>from the item table where the item number from the
>>original form matched the item number in the table but
>>couldn't get that to work either.
>>
>>SQL used: txtName = "SELECT tblItems.ItemName FROM
>>tblItems WHERE tblItems.ItemNumber = txtItemNumber"
>>.
>>

>.
>

[David Tunstall]

Please help.

I want to be able to filter data by selecting it from a
combo box. For example, I have two combo boxes, one with
car makes, i.e Pontiac, Ford, and in the second box is a
list of all the car names, i.e Firebird, Mustang. When I
select Pontiac from the first combo box, I only want the
second combo to list pontiac cars.

Hope you can help. Thanks
David

[Sandra Daigle]

Hi David,

Check out this KB article:

ACC: How to Synchronize Two Combo Boxes on a Form (97624)
[url]http://support.microsoft.com/default.aspx?scid=kb;[/url][LN];97624


--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

David Tunstall wrote:

> Please help.
>
> I want to be able to filter data by selecting it from a
> combo box. For example, I have two combo boxes, one with
> car makes, i.e Pontiac, Ford, and in the second box is a
> list of all the car names, i.e Firebird, Mustang. When I
> select Pontiac from the first combo box, I only want the
> second combo to list pontiac cars.
>
> Hope you can help. Thanks
> David

[dosima]

Hi

i have a 8 combo boxes on a page which lists a quantity amount. this is for
users to buy a certain amount of books.
users have to select from any combo box a certain amount.
they can select a quantity of 8 in total from the different combo boxes.

how can i make it so when the user selects the total amount from the different
boxes and clicks submits, the message saying you have selected too much
quantity you can only select 8

what do i need to do in order to stop users selecting more than what is
allowed.

also could someone help me work out how to include the total price to display
on the next page as well please.

thanks in advance

[Julian Roberts]

You might be better off submitting the form and using a server side language
to process the form.

--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[dosima]

i am using asp dreamweaver and vbscript
but have no idea what to do on the next page for the calculations, or how to limit the quantity

any ideas would be very greatful
thanks in advance