By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,687 Members | 2,065 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,687 IT Pros & Developers. It's quick & easy.

Continuous Forms issue - Blank Records

P: n/a
I've got a continuous form. The query behind it is updateable, but I
don't want the continuous form to display a blank record at the
bottom. I've set AllowDeletions to false, AllowAdditions to false and
DataEntry to false and I can still see the blank record. Is there any
way (besides making the query behind it "not updateable") to prevent
that blank record from showing?

Apr 2 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
ManningFan wrote:
I've got a continuous form. The query behind it is updateable, but I
don't want the continuous form to display a blank record at the
bottom. I've set AllowDeletions to false, AllowAdditions to false and
DataEntry to false and I can still see the blank record. Is there any
way (besides making the query behind it "not updateable") to prevent
that blank record from showing?
AllowAdditions = No

....is what "Should" eliminate the blank record at the bottom. How are you
opening the form? Your arguments to the OpenForm method could be
over-riding the AllowAdditions setting.

Do you only want to disallow additions or any kind of editing? If the
latter you can set the RecordSourceType of the form to "Snapshot". That
should prevent any sort of editing.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Apr 2 '07 #2

P: n/a
On Apr 2, 12:45 pm, "Rick Brandt" <rickbran...@hotmail.comwrote:
ManningFan wrote:
I've got a continuous form. The query behind it is updateable, but I
don't want the continuous form to display a blank record at the
bottom. I've set AllowDeletions to false, AllowAdditions to false and
DataEntry to false and I can still see the blank record. Is there any
way (besides making the query behind it "not updateable") to prevent
that blank record from showing?

AllowAdditions = No

...is what "Should" eliminate the blank record at the bottom. How are you
opening the form? Your arguments to the OpenForm method could be
over-riding the AllowAdditions setting.

Do you only want to disallow additions or any kind of editing? If the
latter you can set the RecordSourceType of the form to "Snapshot". That
should prevent any sort of editing.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Rick -
Thanks for pointing me in the right direction with your suggestion.
I'm editing this form for a co-worker and for some strange reason he
decided to feed it an "acEdit" when he sent the OpenForm method. The
worst part of my job is having to troubleshoot these types of
mistakes...

Apr 2 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.