I simply bring over all the patient meds for the patient I'm working on. The following code takes about a second to execute-

SELECT MEDICATIONS.* FROM MEDICATIONS WHERE MEDICATIONS.STATUS = "CA" AND MEDICATIONS.ACCT = Forms![PtMeds]![ACCT] ORDER BY [MEDICATIONS].[MD1];

("CA" refers to chronic active, the ACCT is patient's account number and the [MD1] field is the medication name)

(picture of my prescription form) https://1drv.ms/i/s!Am9xB7i5mNRoqsAr-3Yksuwq-tlbQA?e=nC66XM

As you can see on this form, I have several variations of this select query, all running in an instantaneous manner. AC has a superior SQL backend, so it should theoretically run better. At emrupdate I used to argue that in a hospital setting, this would hold true, but in an office setting, not so much. If the AC select query is slow, there must be a reason for that which can be easily fixed.

Last edited by alborg; 05/16/2023 1:44 PM.