Forms Read Only Problem

  • Thread starter Thread starter John134
  • Start date Start date
J

John134

I think I inadvertently set a form to read only on my personal computer. I
would like to disable the read only restriction. The properties Allow Edits,
Allow Deletions, and Allow Additions are all set to Yes. The records are not
locked. Does anyone have any suggestions?

John 134
 
I think I inadvertently set a form to read only on my personal computer. I
would like to disable the read only restriction. The properties Allow Edits,
Allow Deletions, and Allow Additions are all set to Yes. The records are not
locked. Does anyone have any suggestions?

John 134
Click to expand...

My guess is that the form is based on a Query which is itself not updateable.
What is the Recordsource of the form? If you open it as a query datasheet, can
you edit it there? If not, open the query in SQL view and post the SQL text
here - there are numerous reasons that a query might not be updateable.

John W. Vinson [MVP]
 
Thanks for your reply, John. Yes, it is a stacked query and neither are
updatable. However, this form was non-read only before something changed it.
I suspect it was from my incorrectly clicking Yes when a dialog box popped
up asking if I wanted it to be read only. These boxes seem to pop up when
you do someting wrong.


Anyway, the underlying SQL statement is:

SELECT Table1.Last, Table1.First, Table1.FullName, Table2.Manufacturer,
Table2.Medication, Table2.[ReNew Complete], Table2.[Enroll Date], (SELECT MIN
([Enroll Date]) FROM Table2 WHERE (Table1.FullName = Table2.FullName)
AND ([Medications TAble].Manufacturer = Table2.Manufacturer)) AS MinDateApp
FROM Table1 INNER JOIN ([Medications TAble] INNER JOIN Table2 ON
[Medications TAble].Medication=Table2.Medication) ON
Table1.FullName=Table2.FullName
WHERE (((Table2.Manufacturer)<>"Rx Outreach") AND ((Table2.[ReNew
Complete])=No) AND ((Table2.[Enroll Date]) Is Not Null))
ORDER BY Table1.FullName, Table2.Manufacturer, Table2.Medication,
Table2.[Enroll Date];
 
Thanks for the link, Bob. I tried one of the tips and it seems to have
solved the problem. On one of the queries, the Unique Value property was set
to Yes. Changing that to No restored my access to the form in question.

John134
 
Back
Top