I have a bound form that is set to continueous mode. When I double click the form it displays
Form Properties:
Default View: Continuous Forms
Record Source: QUERY
Cycle: All Records
In design mode, the form consists of check boxes text fields and combo boxes, all bound to values from the QUERY, so each row in a table represents a record on this form.
When I double click the form, I want to be able to disable some of the controls that for instance have First Name equal to "Alex". I have the conditional, I just don't know where to put it so that it effects all the records that are coming out during load time.
I tried On Open Event but it only works for the first record, but not for the rest. So, if I had 10 records and the form displays all of them, the form will only disable or enable the first record.
Can anyone help me here?
Thanks,
Alex
Form Properties:
Default View: Continuous Forms
Record Source: QUERY
Cycle: All Records
In design mode, the form consists of check boxes text fields and combo boxes, all bound to values from the QUERY, so each row in a table represents a record on this form.
When I double click the form, I want to be able to disable some of the controls that for instance have First Name equal to "Alex". I have the conditional, I just don't know where to put it so that it effects all the records that are coming out during load time.
I tried On Open Event but it only works for the first record, but not for the rest. So, if I had 10 records and the form displays all of them, the form will only disable or enable the first record.
Can anyone help me here?
Thanks,
Alex