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

Multiple table join as form recordsource

P: 4
I created an SQL statement, left joining three tables. When I use the statement as the recordsource for my form in datasheetview, I cannot input data into any of the fields. Can anyone help me with this?

Here is my SQL statement:

strSQL = " SELECT tblAccounts.sNumber, tblAccounts.sName, tblAccounts.sType, tblUnAdj.sngUnAdjDR, tblUnAdj.sngUnAdjCR, tblAJESummary.sngAJEDR, tblAJESummary.sngAJECR " & _
" FROM (tblAccounts LEFT JOIN tblUnAdj ON tblAccounts.ixID=tblUnAdj.intAccount) LEFT JOIN tblAJESummary ON tblAccounts.ixID=tblAJESummary.intAccount; "

Me.RecordSource = strSQL
Aug 23 '08 #1
Share this Question
Share on Google+
2 Replies


missinglinq
Expert 2.5K+
P: 3,532
Assuming that the form's AllowEdits/AllowAdditions are set to Yes, and, if on a network, you have permission to write on the particular folder the db is in, Allen Browne, the "Wonder from Down Under," has an excellent article at this link explaining why queries are read-only.

Welcome to Bytes!

Linq ;0)>
Aug 23 '08 #2

nico5038
Expert 2.5K+
P: 3,072
The general solution to this "problem" is to define a main form, sub form and sub-sub form.
Thus one form for each table.

Nic;o)
Aug 24 '08 #3

Post your reply

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