Sequentials Combo boxes

  • Thread starter Thread starter an
  • Start date Start date
A

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




.
Click to expand...
 
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
 
Back
Top