extra record in continuous form

  • Thread starter Thread starter fishqqq
  • Start date Start date
F

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
 
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
Click to expand...

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
 
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.
Click to expand...

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
 
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.
 
Back
Top