extra record in continuous form

[fishqqq]

I'm sure i knew how to do this once upon a time but for the life of me
i've forgotten.

please tell me how to stop a new "blank" record from appearing on a
continuous form when the user opens it.
I intend to add a button that will create a new record if the user
chooses but would prefer not to see a "blank" one at the bottom of the
"valid" records.

thanks
STeve

 

[John W. Vinson]

please tell me how to stop a new "blank" record from appearing on a
continuous form when the user opens it.

Set the ALLOW ADDITIONS property of the form to No.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[fishqqq]

Set the ALLOW ADDITIONS property of the form to No.
--

             John W. Vinson [MVP]
 Microsoft's replacements for these newsgroups:
 http://social.msdn.microsoft.com/Forums/en-US/accessdev/
 http://social.answers.microsoft.com/Forums/en-US/addbuz/
 and see alsohttp://www.utteraccess.com

Thanks John but when I tried this (previous to the posting) I wasn't
able to add a new record (via a command button w/macro add new
record).

Can you tell me how to turn the Allow Additions to "YES" via a macro -
i'll add that to the beginning of my macro function.

thanks

 

[John W. Vinson]

Can you tell me how to turn the Allow Additions to "YES" via a macro -
i'll add that to the beginning of my macro function.

Simple:

Me.AllowAdditions = True

or (I don't use macros much) possibly

Form.AllowAdditions = True

Alternatively your macro could open a Recordset (the form's recordsetclone)
and add a record to the table directly, or it could run a one-record Append
query.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[jhseymour113]

An additional note about the blank record appearing. If you set AllowAdditions to No in the property sheet in design view (as opposed to setting it with VBA code), then when you open the form with VBA

DoCmd.OpenForm "MyForm", acNormal, , , acFormPropertySettings, acDialog, myOpenARgs

make sure you set the datamode parameter to acFormPropertySettings or you may be surprised to find that your settings on the property sheet are ignored.