Subform Visible based on data present

[Freckles]

I know that this has been discussed, but I can not find the information !

What is wrong with the following

If [subform DATA_ACE Claims A].[BTN] Is Null Then
[subform DATA_ACE Claims A].Visible = False
Else
[subform DATA_ACE Claims A].Visible = True
End If

I get "Run-time error '438: Object doesn't support this property or method"

: Deb Koplen
deb.koplen@verizon.com
koplend@swbell.net (weekends and nights)

A person can stand almost anything except a succession of ordinary days.

 

[PHV]

And what about this ?
[subform DATA_ACE Claims A].Visible = Not IsNull([subform DATA_ACE Claims A].Form.[BTN])

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[KenReay]

Hi

Or if you are trying to hide sub form based on presence/absence of records perhaps

Me.[subform DATA_ACE Claims A].Visible = Me.[subform DATA_ACE Claims A].FORM.Recordsetclone.recordcount > 0
End If



Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK