Continuous Form built from Table

[SteveJR]

Hi,

I have some VBA code that builds a continous form containing text boxes and labels bound to a table. Everything works ok apart from on the form the final text boxes and labels are blank. This is because the form is also picking up the next available row from the table which is blank because no data has been entered into yet.

Is there anyway to stop the last text boxes and labels from being displayed or to inhibit the table creating a next available row?

Thanks,

Steve

 

[LittleSmudge]

Set the 'allow additions' property of the form to False.



.



G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[SteveJR]

Littlesmudege,

Exactly what I needed. Thank you.

Steve