please complete

[deejay_totoro]

Hello all,

Here is the problem: I need to check that a field (on a subform on a tab) has been completed.

Because most of the records have already been keyed in, this particular field is already empty. Now the users must go back and check their data.

Making the field "required" in the underlying table only works for new records.

I think what I really need is as the user moves from one tab to another, a check is done to see if this particular field contains data or not.

So how can I tell the user to input data into a field if the field is empty? How do I check the field if it is on a subform?

Thanks!

dj_T

 

[KenHigg]

In on current event:

if isnull(forms!mymainfrom!mysubform.form!mycontrol) then
do stuff
end if

I think this should work...
???
ken

 

[deejay_totoro]

Great!

Super - I got it to work!

Cheers.

dj_T