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
Thanks,
Sup