How to hide the pre-new record row?

mugen_rsx

Registered User.
Local time
Today, 15:54
Joined
Dec 1, 2004
Messages
20
Not sure how to call that row. On my sub-form, there is always a blank row for you to add new record. How can I hide it. I want to use a button to add a new row (record) instead of having a row ready for me to type in.

THank you
 
This is Access default way of telling that it is allowed to add records in the form.

Perhaps play with the .AllowAdditions property of the form?

In the on current:

if not me.newrecord then
me.allowadditions=false
end if

In the "add button"'s on click event
me.allowadditions=true
docmd.gotorecord,,acnewrec

I think this should allow the user to continue to add records after hitting the Add button, but as soon as they move to an existing record, the the "new row" ins't there anymore
 
Last edited:
I know it is none of my business, but why do you want to use a button to allow additions.
 

Users who are viewing this thread

Back
Top Bottom