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];
