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.
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