I have a subform that is a continuous form.
The first field is a check box. I want the user to be able to select the box and then enable field on the line (record) only and set focus to that field. When I do this now it enables the field for all records. Also, if the box is checked I want to be able to force entry and to check for accuracy.
Example of accuracy, the check box is to select a job to ship, and then I want to ask for "ship qty" but do not want to let them off the record until they enter an amount and it cannot be greater than order qty.
First question, can this be done in the continuous from view? If so, how?
Thanks in advance for any suggestions/help.
Wes
The first field is a check box. I want the user to be able to select the box and then enable field on the line (record) only and set focus to that field. When I do this now it enables the field for all records. Also, if the box is checked I want to be able to force entry and to check for accuracy.
Example of accuracy, the check box is to select a job to ship, and then I want to ask for "ship qty" but do not want to let them off the record until they enter an amount and it cannot be greater than order qty.
First question, can this be done in the continuous from view? If so, how?
Thanks in advance for any suggestions/help.
Wes