why this criteria Do not work

I'm trying to base a combo box in another one
but this Combo named:[ComboPI] does not work
this is the second combo based in another combo named:[ComboCode]

but both are in the same table is it possible.??


this is the source of the second combo box named: [ComboPI]
SELECT tbl_BOMinfo.BOM_ID, tbl_BOMinfo.Base_IDCopy, tbl_BOMinfo.FirstCode
FROM tbl_BOMinfo WHERE
(((tbl_BOMinfo.FirstCode)=Forms!PackInfoForm!ComboCode));



please help me on this.

Thanks.

--
Lorenzo DÃ*az
Cad Technician

Hi Lorenzo,

Try copying the query that you indicated and pasting it into the SQL view of
a new query. To do this, create a new query. Dismiss the Add Table dialog
without adding any tables. In query design view, click on View > SQL View.
You should see the word SELECT highlighted. Replace this with the SELECT
statement that you are attempting to use for ComboPI. Make sure that your
PackInfoForm form is open, and something is selected in the ComboCode combo
box. They try running the query. Does it work correctly?


Tom

http://www.access.qbuilt.com/html/ex...tributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________


"ldiaz" wrote:

> why this criteria Do not work
>
> I'm trying to base a combo box in another one
> but this Combo named:[ComboPI] does not work
> this is the second combo based in another combo named:[ComboCode]
>
> but both are in the same table is it possible.??
>
>
> this is the source of the second combo box named: [ComboPI]
> SELECT tbl_BOMinfo.BOM_ID, tbl_BOMinfo.Base_IDCopy, tbl_BOMinfo.FirstCode
> FROM tbl_BOMinfo WHERE
> (((tbl_BOMinfo.FirstCode)=Forms!PackInfoForm!ComboCode));
>
>
>
> please help me on this.
>
> Thanks.
>
> --
> Lorenzo DÃ*az
> Cad Technician

Hi TOM..

I have created a different query and it's work , thank you for your idea &
support

Thanks

--
Lorenzo DÃ*az
Cad Technician


"Tom Wickerath" wrote:

> Hi Lorenzo,
>
> Try copying the query that you indicated and pasting it into the SQL view of
> a new query. To do this, create a new query. Dismiss the Add Table dialog
> without adding any tables. In query design view, click on View > SQL View.
> You should see the word SELECT highlighted. Replace this with the SELECT
> statement that you are attempting to use for ComboPI. Make sure that your
> PackInfoForm form is open, and something is selected in the ComboCode combo
> box. They try running the query. Does it work correctly?
>
>
> Tom
>
> http://www.access.qbuilt.com/html/ex...tributors.html
> http://www.access.qbuilt.com/html/search.html
> __________________________________________
>
>
> "ldiaz" wrote:
>
> > why this criteria Do not work
> >
> > I'm trying to base a combo box in another one
> > but this Combo named:[ComboPI] does not work
> > this is the second combo based in another combo named:[ComboCode]
> >
> > but both are in the same table is it possible.??
> >
> >
> > this is the source of the second combo box named: [ComboPI]
> > SELECT tbl_BOMinfo.BOM_ID, tbl_BOMinfo.Base_IDCopy, tbl_BOMinfo.FirstCode
> > FROM tbl_BOMinfo WHERE
> > (((tbl_BOMinfo.FirstCode)=Forms!PackInfoForm!ComboCode));
> >
> >
> >
> > please help me on this.
> >
> > Thanks.
> >
> > --
> > Lorenzo DÃ*az
> > Cad Technician