Hello guys:

I have a form named CONTROL_DIARIO, it keeps records on individual house construction development on a project.  It pulls the houses' status info from another form, STATUS_VIVIENDAS.

The house's lot number in the CONTROL_DIARIO form is chosen by the user in a pullout list fed from STATUS_VIVIENDA 's info.  There is a field in STATUS_VIVIENDAS named STATUS, wich describes if the house is being constructed or sold.

If a house in STATUS_VIVIENDAS has the STATUS == constructed or sold, I need to set a in  control script in CONTROL_DIARIO in order to notice the user that the lot he/she has chosen is already finished, so no further information can be added.

Can you help me please?

Thanks!

Alberto