Detect record in sub form

[Tony WONG]

Access version is 2007.

Can i detect number of record in sub-form?
if there is no record, the sub-form.visible = false

it seems no such property in form object.

Thanks.

tony

 

[Allen Browne]

Test the RecordCount of the RecordsetClone of the form in the subform
control.

Access 2007 has a bug where this works only in VBA code, so you will need to
use code such as the FormHasData() function here:
http://allenbrowne.com/RecordCountError.html

 

[Tony WONG]

thanks a lot

i will try next week.

have a nice weekend.