Omit last blank row

[Guest]

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

 

[Guest]

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

 

[Guest]

Ok, Dennis.

Thank you for your reply.
an

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

 

[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

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

 

[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)?

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]