Records In Subform

Kristine · Jul 18, 2003

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 · Jul 18, 2003

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 · Jul 18, 2003

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.

Records In Subform

Kristine

Allen Browne

Bob Quintal