Sequentials Combo boxes

Hello!

I would like to have a form, based in T_AnnualsValues,
with 3 Combo boxes:
1 - CboCompon
2 - CboParam
3 - CboDate

I would like to display in CboCompon, all possible
components to choose one (with SELECT DISTINCT in Row
Source);

in CboParam only records "filtered" through CboCompon;

In CboDate only the records "filtered" through CboParam
(and CboCompon) with all differents dates.

Any help is welcome!
Thanks in advance
an

You need to set up parameter queries to use as the data sours for the Param
and Date combo boxes. The syntax to refer to the value of a form control
is:

Forms!myForm!myControl

where myForm is the name of your form, and myControl is the name of your
control. So, for example, the selection criteria for the Param combobox
query would be:

componentID = Forms!myForm!cboCompon

Then, in the AfterUpdate event of the first two cbo's you need to Requery
the queries.

HTH -- email me if you need an example.

--
Rebecca Riordan, MVP

Seeing Data: Designing User Interfaces
Designing Relational Database Systems, 2nd Edition
www.awprofessional.com

Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step
www.microsoft.com/mspress

"an" wrote in message
...
Hello!

I would like to have a form, based in T_AnnualsValues,
with 3 Combo boxes:
1 - CboCompon
2 - CboParam
3 - CboDate

I would like to display in CboCompon, all possible
components to choose one (with SELECT DISTINCT in Row
Source);

in CboParam only records "filtered" through CboCompon;

In CboDate only the records "filtered" through CboParam
(and CboCompon) with all differents dates.

Any help is welcome!
Thanks in advance
an

See also The Access Web:

http://www.mvps.org/access/forms/frm0028.htm

--
HTH
Van T. Dinh
MVP (Access)


"an" wrote in message
...
Hello!

I would like to have a form, based in T_AnnualsValues,
with 3 Combo boxes:
1 - CboCompon
2 - CboParam
3 - CboDate

I would like to display in CboCompon, all possible
components to choose one (with SELECT DISTINCT in Row
Source);

in CboParam only records "filtered" through CboCompon;

In CboDate only the records "filtered" through CboParam
(and CboCompon) with all differents dates.

Any help is welcome!
Thanks in advance
an

RR,

Thanks for your reply and help.
an

-----Original Message-----
You need to set up parameter queries to use as the data
sours for the Param
and Date combo boxes. The syntax to refer to the value
of a form control
is:

Forms!myForm!myControl

where myForm is the name of your form, and myControl
is the name of your
control. So, for example, the selection criteria for the
Param combobox
query would be:

componentID = Forms!myForm!cboCompon

Then, in the AfterUpdate event of the first two cbo's you
need to Requery
the queries.

HTH -- email me if you need an example.

--
Rebecca Riordan, MVP

Seeing Data: Designing User Interfaces
Designing Relational Database Systems, 2nd Edition
www.awprofessional.com

Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step
www.microsoft.com/mspress

"an" wrote in
message
...
Hello!

I would like to have a form, based in T_AnnualsValues,
with 3 Combo boxes:
1 - CboCompon
2 - CboParam
3 - CboDate

I would like to display in CboCompon, all possible
components to choose one (with SELECT DISTINCT in Row
Source);

in CboParam only records "filtered" through CboCompon;

In CboDate only the records "filtered" through CboParam
(and CboCompon) with all differents dates.

Any help is welcome!
Thanks in advance
an



.

VTD,

Thanks for your sample codes.
an

-----Original Message-----
See also The Access Web:

http://www.mvps.org/access/forms/frm0028.htm

--
HTH
Van T. Dinh
MVP (Access)


"an" wrote in
message
...
Hello!

I would like to have a form, based in T_AnnualsValues,
with 3 Combo boxes:
1 - CboCompon
2 - CboParam
3 - CboDate

I would like to display in CboCompon, all possible
components to choose one (with SELECT DISTINCT in Row
Source);

in CboParam only records "filtered" through CboCompon;

In CboDate only the records "filtered" through CboParam
(and CboCompon) with all differents dates.

Any help is welcome!
Thanks in advance
an



.

RR,

Sorry, but I have some difficulty to apply this procedure.
Grateful for your offer, is possible to see an example,
please?

Thanks in advance.
an

-----Original Message-----
You need to set up parameter queries to use as the data
sours for the Param
and Date combo boxes. The syntax to refer to the value
of a form control
is:

Forms!myForm!myControl

where myForm is the name of your form, and myControl
is the name of your
control. So, for example, the selection criteria for the
Param combobox
query would be:

componentID = Forms!myForm!cboCompon

Then, in the AfterUpdate event of the first two cbo's you
need to Requery
the queries.

HTH -- email me if you need an example.

--
Rebecca Riordan, MVP

Seeing Data: Designing User Interfaces
Designing Relational Database Systems, 2nd Edition
www.awprofessional.com

Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step
www.microsoft.com/mspress

"an" wrote in
message
...
Hello!

I would like to have a form, based in T_AnnualsValues,
with 3 Combo boxes:
1 - CboCompon
2 - CboParam
3 - CboDate

I would like to display in CboCompon, all possible
components to choose one (with SELECT DISTINCT in Row
Source);

in CboParam only records "filtered" through CboCompon;

In CboDate only the records "filtered" through CboParam
(and CboCompon) with all differents dates.

Any help is welcome!
Thanks in advance
an



.