Subform displays last blank row for entry - annoying...

LenkaL used Ask the Experts™

 Hello experts,
 I have a main Form and a Subform.
 Subform is based on a simple query that brings few rows
 into it. But it also displays a blank row, and if you
 type on it it records into the table, as this subform
 is bound.
 I dragged the boundaries of the subform on the MAin form
 so is to conceal this blank row, but if user presses
 PageDown or other keys - this row appears to view.
 How can I get rid of this row? How can I make my subform
 bring only real row records. The table itself doesnt'
 have any blanks, only that same last row for entry.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Set the Allow Additions property of the form to false.

I believe mcallarse meant to say set the Allow Additions property of the SUBform to false.
The form that the subform is based on.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

To elaborate, the blank row is automatically placed there by Access for you to enter a NEW RECORD.  If you set the subform's properties to NOT ALLOW ANY NEW RECORDS, the blank line will not be there.  (ie Allow Additions-False).


Thanks, that was right.
mcallarse answer worked for me too - same situation!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial