• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 304
  • Last Modified:

Remove New/Blank Record on Continuous Form

I have a form with a few unbound fields and no data source. On this form I have a "Continuous Forms" subform that shows a list of records.

How do I turn off the new/blank record on this subform?

(I've tried Me.AllowAddtions=False on Load, Open and Current of both forms but with no success)
0
slamhound
Asked:
slamhound
  • 2
  • 2
1 Solution
 
MikeTooleCommented:
This works for me:
Private Sub Form_Load()
Me.AllowAdditions = False
End Sub
0
 
MikeTooleCommented:
Sorry, hit the wrong key.
In the sub form, this should work:
Private Sub Form_Load()
     Me.AllowAdditions = False
End Sub

Try putting in a debug.print or a msgbox statement to make sure that the routine is being executed.

You could also set AllowAdditions to 'No' in the Data tab of the subform's property sheet.
0
 
slamhoundAuthor Commented:
Is that on the form or the subform?
0
 
peter57rCommented:
I agree; setting allowadditions to false should disable the New button and remove the new record template.
0
 
slamhoundAuthor Commented:
You're right! Went through the code to remove my old junk before trying your sample and found an allowadditions referencing the subform from the main form. It didn't have the "Me." so I had missed it.

Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now