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]

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,

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