Continous forms

[paulmcdonnell]

Hi Guys,

When I use continuous forms the last record in the list is always a blank new entry with my auto number field showing (Auto Number)I don't want it to keep showing me this - how do I get access to stop?

Hope you can help

 

[D-Fresh]

Well, you can get rid of that easily by setting the "Allow Additions" property to no. You won't be able to add records, but it will get rid of that last blank line. Hope that helps.

Doug

 

[KevinM]

Also, if you use a filter and no results are returned then you will be left with a completeley BLANK form and I mean literally blank.
Access needs this new entry line to 'fall back on', so I wouldn't recommend setting AllowEdits to False. If you do then make sure they can't apply any filters too.

 

[D-Fresh]

Right, but you could also run a quick SQL statement On Filter and check if there are any records. If there are no records for that filter, then you can take the filter off.