Check Box updates using VBA

[CArlee Grant]

Hi there

I have a one to many relationship between Location and Building. That is, one Location can have many buildings. I have a master form with toombstone Location info and a child continuous form for the buildings on each location. In addition, I have a check box field on the location master form that identifies a location as inspected or not (yes/no). I also have a check box field on the building child subform which indicates if each building has been inspected. ( yes/no

Problem

If a building is checked inspected, i want have all other buildings and the location inspected check box to be updated automatically? How can i do thi

Many thanks for your hel
Carlee

 

[Dirk Goldgar]

Hi there,

I have a one to many relationship between Location and Building.
That is, one Location can have many buildings. I have a master form
with toombstone Location info and a child continuous form for the
buildings on each location. In addition, I have a check box field on
the location master form that identifies a location as inspected or
not (yes/no). I also have a check box field on the building child
subform which indicates if each building has been inspected. (
yes/no)

Problem:

If a building is checked inspected, i want have all other buildings
and the location inspected check box to be updated automatically?
How can i do this

Many thanks for your help
Carlee

I don't understand. Are you saying that if any building on a location
has been inspected, all other buildings on that location, and the
location itself, must also have been inspected? If that is the case,
why have an "inspected" check box for each building at all? Why not
just have the check box for the location alone? Or is it possible for a
location and its buildings to have different "inspected" status?