Hello,
I am a newbie in Access and working on my first data base (cannot attach, as size exceeds limit). Basically, upon opening, a form representing the main user screen should pop up and users should be able to add project records on a blank form.
On the entry form there are three cascading boxes (cboProcure21, cboContractType and cboContractSubtype).
In cboProcure21 we should have "Yes" and "No". If user selects "Yes", then cboContractType and cboContractSubtype should be set to specific values (only one option for each).
However, if user selects "No", in cboContractType they should be able to select two values, which in turns populates the cboContractSubtype with a list of options accordingly.
I managed to set up the dependency between cboContractType and cboContractSubtype using a query based on related tables, however, I have no idea how to set up the dependency with the cboProcure21 box.
Would you be able to help me please?
Thanks a lot,
Zara
I am a newbie in Access and working on my first data base (cannot attach, as size exceeds limit). Basically, upon opening, a form representing the main user screen should pop up and users should be able to add project records on a blank form.
On the entry form there are three cascading boxes (cboProcure21, cboContractType and cboContractSubtype).
In cboProcure21 we should have "Yes" and "No". If user selects "Yes", then cboContractType and cboContractSubtype should be set to specific values (only one option for each).
However, if user selects "No", in cboContractType they should be able to select two values, which in turns populates the cboContractSubtype with a list of options accordingly.
I managed to set up the dependency between cboContractType and cboContractSubtype using a query based on related tables, however, I have no idea how to set up the dependency with the cboProcure21 box.
Would you be able to help me please?
Thanks a lot,
Zara