Hello
I have problem in combobox
I have table in 2 fields has combobox. Field1 is SCNO & Field2 is ItemNo.
ItemNo combobox looks another table called ItemList Table. And SCNO combobox
look another table call SubCodeList whish has ItemNo field too.
Problem is SCNO combobox lists all the subcode no. that SubCodeList table has.

I need to get SCNO in the combobox , only for the ItemNo that I Select in
combobox of field ItemNo. What code should I write for this combobox?

Andy

Andy,
there is a sample database you can download called CascadingComboBoxes.mdb
( beginner )
This sample illustrates how to restrict the value of one combo box based on
the value of another.

http://www.rogersaccesslibrary.com/d...ComboBoxes.mdb

Jeanette Cunningham


"Andy" <(E-Mail Removed)> wrote in message
news:CF3D78D4-58D8-41E0-A53A-(E-Mail Removed)...
> Hello
> I have problem in combobox
> I have table in 2 fields has combobox. Field1 is SCNO & Field2 is ItemNo.
> ItemNo combobox looks another table called ItemList Table. And SCNO
> combobox
> look another table call SubCodeList whish has ItemNo field too.
> Problem is SCNO combobox lists all the subcode no. that SubCodeList table
> has.
>
> I need to get SCNO in the combobox , only for the ItemNo that I Select in
> combobox of field ItemNo. What code should I write for this combobox?
>
> Andy

Thank You Jeanette,

I was realy looking this what u answered me . You are genious. Thanks again

"Jeanette Cunningham" wrote:

> Andy,
> there is a sample database you can download called CascadingComboBoxes.mdb
> ( beginner )
> This sample illustrates how to restrict the value of one combo box based on
> the value of another.
>
> http://www.rogersaccesslibrary.com/d...ComboBoxes.mdb
>
> Jeanette Cunningham
>
>
> "Andy" <(E-Mail Removed)> wrote in message
> news:CF3D78D4-58D8-41E0-A53A-(E-Mail Removed)...
> > Hello
> > I have problem in combobox
> > I have table in 2 fields has combobox. Field1 is SCNO & Field2 is ItemNo.
> > ItemNo combobox looks another table called ItemList Table. And SCNO
> > combobox
> > look another table call SubCodeList whish has ItemNo field too.
> > Problem is SCNO combobox lists all the subcode no. that SubCodeList table
> > has.
> >
> > I need to get SCNO in the combobox , only for the ItemNo that I Select in
> > combobox of field ItemNo. What code should I write for this combobox?
> >
> > Andy
>
>
>