By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,905 Members | 2,001 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,905 IT Pros & Developers. It's quick & easy.

Allow Additions on Sub-form

P: n/a
I'm trying to create the following:

When a user opens a form, if the form's Sub-form has a record, then
they have to click a command button in order to add a new record. If
the Sub-form does not have a record, then a new record in that sub-
form is shown. Actually it doesn't even matter if a new record is
shown. Thye can still click the command button to add a record. I
just don't know how to identify that sub-form in the On Click Event of
the Main Form if the command button is on the main form.

Thanks for the help!

Chris

Feb 5 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
I figured it out.
Me.SubFormName.Form.Allow Additions = False

On Feb 5, 10:33 am, "chris" <chrisvett...@yahoo.comwrote:
I'm trying to create the following:

When a user opens a form, if the form's Sub-form has a record, then
they have to click a command button in order to add a new record. If
the Sub-form does not have a record, then a new record in that sub-
form is shown. Actually it doesn't even matter if a new record is
shown. Thye can still click the command button to add a record. I
just don't know how to identify that sub-form in the On Click Event of
the Main Form if the command button is on the main form.

Thanks for the help!

Chris

Feb 5 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.