By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,105 Members | 2,300 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,105 IT Pros & Developers. It's quick & easy.

Please Help: Subform entries are updating in Souce Tables

P: 29
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
Share this Question
Share on Google+
2 Replies

P: 25
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

P: 29
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.