Checkbox

[Linda]

I have a form with four fields area, org, suborg and delete. Delete is a
boolean field.
I want to be able to click a checkbox on the area org record and then have
the all the area org suborgs matching the area org that I checked be checked
automatically.

But, if I click a record that has an area org suborg, I only want that line
to be clicked.

area org suborg delete

100 1000 X
100 1000 01
100 1000 02
200 1000
200 2000 02
200 2000 03

Thanks in advance.

Linda

 

[Atilla Yildirim]

put on enter event a code like;

currentdb.execute "update area_org_table set delete=true where area=" &
me.area & " and org=" & me.org"
me.requery

if area and org is a number field... if both text fields put single
quotation around.

Atilla