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 " & _...
fastPace
Last Activity: Aug 29 '08, 05:11 PM
Joined: Dec 14 '07
Location:
-
Multiple table join as form recordsource
-
I tried using a bound subform with unbound controls and I enter data in the first line of the subform but it won't drop down to the next line. I assume I have so save each record before I can move onto the next.
So I can't use the button to populate multiple records at the same time; is that correct? -
Thanks a bunch. I will try this out!Leave a comment:
-
Sub Forms
I have been using a sub form to accumulate data, however, the data is bound. Is there a way I could do something similar but have the data be unbound until I decide I want to keep it? Kind of like an unbound data grid.
No activity results to display
Leave a comment: