PC Review


Reply
Thread Tools Rate Thread

continuous form & extra record

 
 
fishqqq@hotmail.com
Guest
Posts: n/a
 
      14th Mar 2011
Hi Can anyone tell me how to prevent a continuous form from adding a
"blank" record at the end. I would like the screen to only show active
records not an extra blank record if possible.

tks
 
Reply With Quote
 
 
 
 
John W. Vinson
Guest
Posts: n/a
 
      14th Mar 2011
On Mon, 14 Mar 2011 06:49:10 -0700 (PDT), "(E-Mail Removed)"
<(E-Mail Removed)> wrote:

>Hi Can anyone tell me how to prevent a continuous form from adding a
>"blank" record at the end. I would like the screen to only show active
>records not an extra blank record if possible.
>
>tks


Set the "Allow Additions" property of the form to False.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/For...-US/accessdev/
http://social.answers.microsoft.com/.../en-US/addbuz/
and see also http://www.utteraccess.com
 
Reply With Quote
 
fishqqq@hotmail.com
Guest
Posts: n/a
 
      14th Mar 2011
On Mar 14, 11:39*am, Marshall Barton <marshbar...@wowway.com> wrote:
> fish...@hotmail.com wrote:
> >Hi Can anyone tell me how to prevent a continuous form from adding a
> >"blank" record at the end. I would like the screen to only show active
> >records not an extra blank record if possible.

>
> Set the form's AllowAdditions property to No.
>
> --
> Marsh
> MVP [MS Access]


Great thanks Marsh
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
extra record in continuous form fishqqq@hotmail.com Microsoft Access Form Coding 3 4th May 2011 08:39 PM
Open form to specific record from button on continuous form sml Microsoft Access Form Coding 4 14th Jan 2010 01:59 PM
Record Selectors on continuous form seem to select wrong record Garyth Microsoft Access Form Coding 5 9th Jul 2009 04:30 AM
Checkbox on continuous form breaks navigation from record to record Yarik Mezheritsky via AccessMonster.com Microsoft Access Forms 0 2nd Jun 2005 06:49 AM
EXTRA RECORD IN CONTINUOUS FORM 111 Microsoft Access Forms 2 26th Mar 2004 10:25 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:22 AM.