Preventing new records from being added

G

Gina K

Hello,

I have a form (set to continuous form view) based upon a query. Is there a
way to prevent the blank new record line from being displayed, but still
maintain the ability to make changes to all the existing records?

Thanks.
 
D

Dirk Goldgar

Gina K said:
Hello,

I have a form (set to continuous form view) based upon a query. Is
there a way to prevent the blank new record line from being
displayed, but still maintain the ability to make changes to all the
existing records?
Click to expand...

Set the form's Allow Additions property to No, on the Data tab of the
form's property sheet in design view.
 

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

Can a Check Box Prevent Other Fields from Being Used? 1
DLookup in Continuous form 0
How do I clear a form? 0
DMax on existing record to increment serialized # fails 1
Prevent the user from adding a new record while still allowing him tomodify existing records 2
Prevent going to New Record 4
Prevent Navigating Past Last Record 3
Using list box adds blank record to lookup table 1

Top