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

Getting Rid of Blank Record showing in Continuous Form

P: 4
How do I get rid of the blank form that attach to the current form when you start to enter data into a continuous form? I want the blank form to only appear after they click on the ADD Record button and not automatically.

I have tried to play around with allow addition and data entry and put them in before insert, after insert, on current but yield disappointing result. My initial setting where I set allowedit, addition, deletion and data entry = true works well under On form Open event but when i start to enter data... the annoying blank form just pops up and worst of all, start responding to Option group selection.

It does work when you set allow addition = false in After Insert event but it means I have to endure the annoying blank form until I click on save.

I'm using Access 2003.

Please help.
Jun 7 '07 #1
Share this Question
Share on Google+
3 Replies


missinglinq
Expert 2.5K+
P: 3,532
Hate to tell you, but I think as long as you're in Allow Additions = True mode you're always going to have that extra blank line waiting. If it's that annoying to you, then what I'd do is set Allow Additions to False for your continuous form then do is:

Have your Add Record button open up a small singleview form for entering the new record

Have the Navigation box for that form turned off

Have a Save button that you user has to click on when done, saving the record, requerying your record source then returning to your continuous form.
Jun 7 '07 #2

P: 4
Hate to tell you, but I think as long as you're in Allow Additions = True mode you're always going to have that extra blank line waiting. If it's that annoying to you, then what I'd do is set Allow Additions to False for your continuous form then do is:

Have your Add Record button open up a small singleview form for entering the new record

Have the Navigation box for that form turned off

Have a Save button that you user has to click on when done, saving the record, requerying your record source then returning to your continuous form.

Thank you for your reply. :)

I have done that and actually set it using code assigned to AfterUpdate on my first control. The effect... the whole form turned blank. I have again tried to set the default view using code but Access only allowed such setting in design view and not during runtime. Mad!

Yes, the add, save, delete and even a Done button were in place, no navigation box but I'll try your idea of popping up another form for data entry. Worst of all, i'll just revert back to single form. Microsoft guys...if you are reading this... please take note...

Good day. Clear blue sky here in Kuching, Sarawak, Malaysia.
Jun 7 '07 #3

missinglinq
Expert 2.5K+
P: 3,532
Sorry, forgot to say your single view form needs to be bound to the same query/table as your first table is.
Jun 8 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.