Multiple table join as form recordsource

[fastPace]

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.sNu mber, tblAccounts.sNa me, tblAccounts.sTy pe, tblUnAdj.sngUnA djDR, tblUnAdj.sngUnA djCR, tblAJESummary.s ngAJEDR, tblAJESummary.s ngAJECR " & _
" FROM (tblAccounts LEFT JOIN tblUnAdj ON tblAccounts.ixI D=tblUnAdj.intA ccount) LEFT JOIN tblAJESummary ON tblAccounts.ixI D=tblAJESummary .intAccount; "

Me.RecordSource = strSQL

[missinglinq]

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)>

[nico5038]

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)