Suppress next blank record in a form?

K

KB

I have a form, in which I want to force users to click the new record
box (so I can freeze some rates to that record). However, Access
always shows the next available blank record - so they could create a
new record, bypassing my code to lock in my rates.

My form is using a query. Access 2k.

Thanks!
 
J

John Vinson

I have a form, in which I want to force users to click the new record
box (so I can freeze some rates to that record). However, Access
always shows the next available blank record - so they could create a
new record, bypassing my code to lock in my rates.

My form is using a query. Access 2k.

Thanks!
Click to expand...

Set the AllowAdditions property of the Form to No.

John W. Vinson[MVP]
 
K

KB

Pefect, however since I was using the do.cmd method for adding a new
record I had to me.allowadditions = false before the docmd, then in
the form after insert turn it back on.

Thanks!
 
Top