Continuous form showing new record

[NISMOJim]

Hello,

I'm using a continuous form as a list of potential visitors to a work site. I'm using a form instead of a report, because there is a checkbox on each record for the boss to approve each visitor. Everything is working fine, except one small annoyance...after the last record is a blank new record. The form is opened with a command button that opens the form in edit mode, and the "Allow Additions" property is set to "No". If I open the form, then change to design view, change the "Allow Additions" to "Yes", and back to "No", the new record goes away when I go back to form view. When I close the form then open it again, the new blank record is back at the bottom again. Isn't the Allow Additions property supposed to keep this from happening, or is there something else I can do to keep a new record from showing at the end of the form?



Thanks for the help.

[CJ_London]

If you don't want the new record then Allow additions should be No.

Having set this value, you do need to save the form.

It may be you are changing this setting with your openform command - it should be set to acFormEdit or acFormPropertySettings or left blank

[Missinglinq]

...It may be you are changing this setting with your openform command...

That's exactly the problem! Using

DoCmd.OpenForm "SecondaryFormName", , , , acFormEdit

allows Records on the secondary Form to be Edited and to have New Records added...overwriting the AllowAdditions setting, done in the Property Pane. To get around this you need to set the property when the secondary Form opens:

Private Sub Form_Load()
 Me.AllowAdditions = False
End Sub

linq ;0)>

[NISMOJim]

Thanks Linq, that did the trick!

[Missinglinq]

Glad we could help!

Linq ;0)>