S
skyrise via AccessMonster.com
First Issue:
I have conditions set up in my database to lock or unlock fields or subforms
based on the selection in the field that comes before it.
I’m having difficulty locking a subform that comes after a conditional
subform. I don’t quite know how to write or where to place the script. I’ve
tried event procedures in the preceeding subform’s form and specific field
properties. Neither appears to be working.
For Example, I have subform “Excluded Ethnicity Groups†that is followed by
subform “Other Excluded Ethnicity Groupsâ€. From the “Excluded Ethnicity
Groups†subform, the user can select several groups and an option for “Otherâ€.
If “Other†is not selected, then the second subform is locked. If “Other†is
selected, then the second Subform is unlocked.
Second Issue:
I’m having difficulty getting the cursor to enter the subform in the correct
field. Currently, the cursor enters the subform based the last field that
was used on the previous record (placing the focus on the field that comes
after it). This is despite trying event procedures to set the focus on the
correct field.
I have conditions set up in my database to lock or unlock fields or subforms
based on the selection in the field that comes before it.
I’m having difficulty locking a subform that comes after a conditional
subform. I don’t quite know how to write or where to place the script. I’ve
tried event procedures in the preceeding subform’s form and specific field
properties. Neither appears to be working.
For Example, I have subform “Excluded Ethnicity Groups†that is followed by
subform “Other Excluded Ethnicity Groupsâ€. From the “Excluded Ethnicity
Groups†subform, the user can select several groups and an option for “Otherâ€.
If “Other†is not selected, then the second subform is locked. If “Other†is
selected, then the second Subform is unlocked.
Second Issue:
I’m having difficulty getting the cursor to enter the subform in the correct
field. Currently, the cursor enters the subform based the last field that
was used on the previous record (placing the focus on the field that comes
after it). This is despite trying event procedures to set the focus on the
correct field.