470,822 Members | 1,415 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,822 developers. It's quick & easy.

Please Help: Subform entries are updating in Souce Tables

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:

Expand|Select|Wrap|Line Numbers
  1. 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
  2. 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

Nov 25 '08 #1
2 1202
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

Nov 25 '08 #2
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.

Nov 25 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

28 posts views Thread by stu_gots | last post: by
1 post views Thread by William Bradley | last post: by
4 posts views Thread by armitageshanks | last post: by
2 posts views Thread by charissav | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.