add record in the subform

  • Thread starter Thread starter lee
  • Start date Start date
L

lee

Hi,
I have a data entry form with subofrms, like to control
the allow addition property in the subform. Where to put
the code in the main form or subform? which event ? and
syntax?
Another thing confused me is how the user were able to
add new records? Because the subform don't have "record
selectors" or "navigation button" and I disabled the page
up,down event, so how can they added new reocrds.
Thanks a lot.
 
Here is how to refer to it from the main form...

Me!YourSubFormControlName.Form.AllowAdditions = False

From the subform...

Me.AllowAdditions = False

As to where to put it, that depends on your criteria for
when or why you would want to allow or disallow the users
ability to add one. If you explain the rationale, we would
have a better idea.

As to how they did it before, they may have gone to
Insert/NewRecord on the menu bar <gr>.

Gary Miller
Sisters, OR
 
Back
Top