Not allowing a Blank Record on a Form

  • Thread starter Thread starter Chip
  • Start date Start date
C

Chip

Howdy from Oklahoma!!!

I am relatively New to ACCESS and VB so please do not get too Technical with
the VB.

I have a form that is filtered but i do not want the form to go to a New
Record at all. This form will only be used to update records that are
already there not to add new records. Is this possible?

And THANK YOU in Advance!!!!
 
Try setting the form properties to not allow new records.

Open the form in design view
Right-click an area off of the form
Select Properties
Select the Data tab
Set the Allow Additions to No
 

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

Opening a form to a New Record 2
Going to first record 0
Separate Form 0
Having the Subform save a record even if it is Blank 1
blank form, can't insert new record 11
DMax on existing record to increment serialized # fails 1
Open Form Artificially Blank 5
Manipulating data in another table with a Form 6

Back
Top