I am not sure whether this is a table or a form query so I am posting it under both. I have a form which is used to amend, delete and create new records. However, when a new record is created, information which is not editable by the user is added from a number of different tables, system date etc etc. In order to achieve this, I have a "new record" button which performs all the necessary code. However, I cannot stop users using the navigation buttons (created in the form, not on the bar at the bottom) going past the last record to a blank form in which they can apparently create a new record - but without all the detail that they can't see. Is there a way of stopping the user going beyond the last record to a blank one?

Change the "Allow Additions" property in the form to No...? I don't know if this what you want...


~ Joe

[This message has been edited by The L&L Company (edited 03-16-2001).]

Disbable the New Record button except for some specific conditions existing.

Thanks for the reply,llkhoutx. However if you had bothered to read my original query, you would see that it is not the New Record button which is the trouble but the fact that I cannot stop the navigation buttons going to the blank record at the end of the table.

Set the cycle property of the form to Current Record, this will stop users from tabbing to a new record, accidentally.
With AllowAdditions set to No this should prevent your problem.

If you need to move between records on this form you will have to add navigation buttons if you change the property.

HTH

Ian