Allow additions NO problem

supmktg

Registered User.
Local time
Today, 12:52
Joined
Mar 25, 2002
Messages
360
I have a form that is used to allow users to edit existing records in an SQL server database. The recordsource for the form is a query. There is a combo box on the form which is tied to the criteria of the query, for selecting the record to be edited. I am trying to remove the ability to add new records to the table through this form. When I set the Allow Additions property to NO, the form opens with no controls visible. What am I doing wrong? Is there a better way to create a single form to find and edit a record?

Thanks,
Sup
 
in the form porperties set data entry to no
 

Users who are viewing this thread

Back
Top Bottom