Checking if subform is displaying a record

[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

 

[TC]

Answered elsewhere.

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

TC

 

[Guest]

Thanks. Sorry about the multi-post. I'll be sure to not
do that again.