Form/Subform Help

[Djbell]

Hi All

I have a form that has a subform in Datasheet view. What I want is a text box on the main form that looks through the records of a particular field on the subform and gives a statement in red saying "Missing Values" if there is any records that do not have values in them for that particular field.

Regards

Djbell

 

[JoanneM]

one way would be to put in the oncurrent event of the form

iif(isnull(forms!formname!subformname.form!txtboxname) ,me!missingvalues = "missing values", me!missingvalues = "&quot
me.repaint

but this would slow up the form a little

another way which is far less resuource hungry is to make your subforms data be sourced by a query
add an extra field to the query called say
DISP_Missing:iif(len(tblname!fieldname) =0) ,"Missing DATA", "&quot
this will then populate the information you want into the the subform
then all you have to do is reference the subform field - DISP_Missing from the unbound txtbox and job done


hope this helps

jo