Sequentials Combo boxes

[an]

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

 

[Rebecca Riordan]

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

 

[Van T. Dinh]

See also The Access Web:

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

 

[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]

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]

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