extra record in continuous form

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
 
F

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
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top