Records In Subform

[Kristine]

What is a good way in a main form's OnCurrent event to determine if there are
any records in the subform?

Thanks!

Kristine

 

[Allen Browne]

The subform records won't be loaded until after the main form's Current
event.

Could you DLookup() the subform's table to determine if there are any?
If you need help with DLookup(), see:
http://users.bigpond.net.au/abrowne1/casu-07.html

 

[Bob Quintal]

What is a good way in a main form's OnCurrent event to determine if
there are any records in the subform?

Thanks!

Kristine

me.SubformName.form.count >0

substitute the name of your subform for mine.