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

Adding new records to continuous forms

P: 166

I was wondering how to add a record to a continuous subform, whose
control source is a query. I went to the query to see if I could add a
row to the query, no luck. Here is the query:
Expand|Select|Wrap|Line Numbers
  1. SELECT MixSample.DM_Mix, MixSample.DM_MaterialNo, MixSample.matTypeID,
  2. MixSample.materialID, MixSample.matBatchWeight, MatType.matType,
  3. Material.material, Material.materialGrav, GetYield([MixSample].
  4. [matTypeID],[matBatchWeight],[Material].[materialGrav]) AS DMYield,
  5. MixSample.pigPercent, MatPrices.matPrice, GetMixCost([MixSample].
  6. [matTypeID],[matBatchWeight],[matPrice]) AS DMMixCost
  7. FROM MixDesign INNER JOIN ((Material INNER JOIN MatPrices ON
  8. Material.materialID = MatPrices.materialID) INNER JOIN (MixSample INNER
  9. JOIN MatType ON MixSample.matTypeID = MatType.matTypeID) ON
  10. Material.materialID = MixSample.materialID) ON MixDesign.DM_Mix =
  11. MixSample.DM_Mix
  12. WHERE (((MatPrices.matPriceActive)=True));
Does it have something to do with the fact that the query has
calculated values?
Dec 8 '08 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 3,532
Have a look at Allen Browne's excellent explanation of why queries are read-only:

Microsoft Access tips: Why is my query read-only?

Linq ;0)>
Dec 8 '08 #2

Post your reply

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