Can't update records in form with Query recordsource.

  • Thread starter Thread starter DocBrown
  • Start date Start date
D

DocBrown

I have two tables related via an ID field. I have form that is based on a
query on the two tables. When I base the report on only the secondary table,
not a query, I can enter data for that table. But when I set the record
source to use a query, I can't enter data. I'm sure it's something small I'm
over looking.

Here's the query:

SELECT Volunteers.VolunteerID, Volunteers.FirstName, Volunteers.LastName,
Volunteers.SchoolName, Volunteers.TotalHours, VolunteerLog.LogDate,
VolunteerLog.TimeIn, VolunteerLog.TimeOut
FROM Volunteers INNER JOIN VolunteerLog ON Volunteers.VolunteerID =
VolunteerLog.VolunteerID;

The form is mainly trying to update the secondary table, Volunteerlog, but
I'm ultimately going to take the TimeIn and TimeOut functions to generate
code to accumulate the log time value into the total hours field. There is a
multi column combobox on the form that is bound to volunteerID whose record
source displays the firstname/lastname field.

Any suggestions, let me know if you need more info.
Thanks,
john
 
You Nailed it. Thanks for the pointer! The Join in my query was going the
wrong direction from the tables.

Thanks for the quick reply!
John
 
Back
Top