Camilla has attended:
Access Introduction course
Disabling record additions in query results
Hi
I am trying to find a way that will disable the ability to add a new record in the results of a query.
I have managed to show the results of the query in a form and have disabled additions in there but wondered if i could also do a similar thing in the tabular view of the query results.
I am allowing the user to choose which way they view the results (in a table or in forms)
Thanks
Camilla
RE: Disabling record additions in query results
Hi Camila
Thanks for your question
The short answer is that there is no easy way to prevent the editing and updating of a query. It is however, unnecessay as data should always be viewed through forms and never directly in tables or queries.
To get the "feel" of looking at the data in the table, create a second form to your existing one and set its default view to "Datasheet". Thus you form will look as if you are viewing it in the original table.
Regards
Stephen
