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:

[COLOR=black][FONT=Verdana]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[/FONT][/COLOR]
[FONT=Verdana][COLOR=black]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;[/COLOR][/FONT]

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

 

[Adigga1]

You have code in the form that is dirtying the record. This is causing Access to save it.

Hi Pat,

Sorry for the late response; How do I clean this bad code up? Where do I start? I'm still sort of a newbie at this. I Will upload a copy of the database to diagnose. Will this assist any?