Different Criteria from forms

[WJReid]

Hi All,



I have 3 forms, the first is Categories, the second Procedures and the third is Sub_Procedures.
The problem that I have is that I want to open the Procedures form with different criteria depending on whether it is being opened from the Categories or the Sub_Procedures form.
All of the forms are contiuous record forms, so if the Categories form Compliance_ID field is changed, then the Procedures form should be updated so that all of the Procedure_Compliance_IDs for the Category chosen would be updated to the Category Compliance_ID.
If the Procedures form is opened from the Sub_Procedures form, I need the Procedure_Compliance_ID to be updated to an Integer passed from the Sub_Procedure form.

I have tried several different ways to get this to work, but I have been unsuccessful.

Bill

[maximus]

can you explain you proble with an example may be then I will be able to understand your problem better.

[Datagopherdan]

If you don't want to place a command button on each one of the forms to open the same form then how about making a double-click event on a field in each one of the forms. This way each form will have it's own procedure with the correct criteria for opening the form.

Hi All,

I have 3 forms, the first is Categories, the second Procedures and the third is Sub_Procedures.
The problem that I have is that I want to open the Procedures form with different criteria depending on whether it is being opened from the Categories or the Sub_Procedures form.
All of the forms are contiuous record forms, so if the Categories form Compliance_ID field is changed, then the Procedures form should be updated so that all of the Procedure_Compliance_IDs for the Category chosen would be updated to the Category Compliance_ID.
If the Procedures form is opened from the Sub_Procedures form, I need the Procedure_Compliance_ID to be updated to an Integer passed from the Sub_Procedure form.

I have tried several different ways to get this to work, but I have been unsuccessful.

Bill