Omit last blank row

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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...
 
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
 
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]
 
Back
Top