Suppress next blank record in a form?

  • Thread starter Thread starter KB
  • Start date Start date
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!
 
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]
 
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!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How does one eliminate blank records on a query result? 3
Select Record in query, save as New Record then edit New Record 1
Next Record : Want it to stop going through next blank record reco 2
previous record not showing 3
Tabbing produces next record in form 3
How many lines are in a continuous form 2
two forms, same table 5
Suppress Blank Record 3

Back
Top