Omit last blank row

A

an

Hello!

I have a continous form.
When I open it, in last row to appear a blank record.
How is possible to avoid it, please.
Thanks in advance.
an
 
D

Dennis

The last row is there so you can add new records. If you wish to omit it, you
will not be able to add new records unless you create a button or some other
routine to add them. To remove the last row, change the form property Allow
Additions from Yes to No
 
A

an

Ok, Dennis.

Thank you for your reply.
an

Dennis said:
The last row is there so you can add new records. If you wish to omit it, you
will not be able to add new records unless you create a button or some other
routine to add them. To remove the last row, change the form property Allow
Additions from Yes to No
Click to expand...
 
S

Steven Greenberg

The last row is there so you can add new records. If you wish to omit
it, you will not be able to add new records unless you create a button
or some other routine to add them. To remove the last row, change the
form property Allow Additions from Yes to No
Click to expand...

I too would like my subform to not show the blank row, I also have a button
to add a new record who's coding is simply goto newrecord. When I set allow
additions to no. the button gives me a debug error saying can't go to
record. Does the coding need to be fancier (like turn back on allow then
add then shut it back off)? or am I barking up the wrong tree?
Thanks
Steve
 
J

John Vinson

I too would like my subform to not show the blank row, I also have a button
to add a new record who's coding is simply goto newrecord. When I set allow
additions to no. the button gives me a debug error saying can't go to
record. Does the coding need to be fancier (like turn back on allow then
add then shut it back off)?
Click to expand...

Exactly: Allow Additions = No means that no additions are allowed
using the form; if you want to allow additions, then you need to
change that setting.

John W. Vinson[MVP]
 
P

paulpenta

Hi Dennis,

I had the same problem, and got that fix from this forum and it worked. But
now it doesn't. What could I have done to mess that up?

Paul
 
Top