Please Help: Subform entries are updating in Souce Tables

[adigga1]

Good Day Experts,


I have an issue dealing with a subform operation whereby, each time I select the value field of the subform, that same value is then placed into the source table as a new record:

I do not want this to occur! What I want is for the subform to just reference the data contained in the source table and only be reflected in the Query that I had set up where my subform was created and runs from.

Here is my code from the main Select Query that the Subform was built from:

SELECT T_Ccpt.CPTcode, T_Ccpt.Charge, T_Ccpt.[Date of Service], T_Ccpt.ModNum, T_Physicians.TaxID, T_Physicians.HospitalName, T_PatientCase.AcctNnum, T_PatientCase.DonorNum, T_PatientCase.InsuranceID
FROM T_Physicians INNER JOIN (T_Ccpt INNER JOIN T_PatientCase ON T_Ccpt.CptNum = T_PatientCase.CptNum) ON T_Physicians.TaxIDNum = T_PatientCase.TaxIDNum;

Again, the Query and derived Subform runs fine, but all of the Table fields selected in the above query are being updated as new records in the source tables, which I don’t want (it’s a Select Query by the way), so no updates to the tables should be occurring in the Tables, Correct?

How do I address this issue?

Thank you in advance

Adigga1

[overcomer]

hi,
you may want to check the record source of your subform. this should be the query name instead of the table name of your source table.


hope this help

regards,

[adigga1]

@overcomer
Thanks for the reply Overcomer;

Thats the issue that I'm having, That code is the query that the subform in question is built from, the subform wasnt built directly from the tables.

Thanks