Checking if subform is displaying a record

  • Thread starter Thread starter Sergio
  • Start date Start date
S

Sergio

Hi,

I'm hoping someone can help me out.

I have a main form with 4 subforms. When the main form
loads, I need to check each subform to determine if it is
displaying a record. If any of the subforms are
displaying records, I need to set their "Allow additions"
option to "NO". I've tried to do this using
RecordsetClone in the current event of the main form, but
I get an error stating that the subform cannot be found.

The reason I'm trying to do this is that I need to limit
the users so they can only create one record per subform,
per form. I can't set the "allow additions" to "NO" as a
default value because if there isn't a record already
available for the subform to display, it won't display at
all and users can't add records.

Thanks

-Sergio
 
Answered elsewhere.

Sergio, please don't "multi-post". See my other reply for what that is, and
how to avoid it.

TC
 
Back
Top