Set Focus to a null value in a continuous form

[Kevin D.]

In continuous FormA I have a field named "Purchased". Before closing FormA,
I have a proceedure which checks for a null value for "Purchased" in all
records and prevents closing the form if there is a null value. My question
is this.... If 1 out of say 10 records has a null value in field "Purchased",
is there a way to get the focus to the record with the null value after I
prevent FormA from closing?

Thanks,

kd

 

[Beetle]

If it is against your business rules to have a null value in the Purchased
field, then you should not be waiting until the the forms Close event
to enforce the rule! You should be doing it at the table level or in the forms
Before Update event.