I have a form I just made that will not let my type in any of the fileds and it is making me pull my hair out and I do not have much to spare.
Ok the DB is Access 2k I have this form based on a query. I have compared the forms' properties with another form I use that allows updates with no problem. So, the only thing I can think is that maybe the query in some way shape or form will not allow the form to update.
Here is the query
SELECT Client_Tbl.RegNum, Client_Tbl.Last, Client_Tbl.First, Goal_tbl.Goal, Objective_tbl.Objective, Objective_tbl.Objective_notes, Objective_tbl.Addnote
FROM (Client_Tbl INNER JOIN Goal_tbl ON Client_Tbl.RegNum = Goal_tbl.RegNum) INNER JOIN Objective_tbl ON Goal_tbl.GoalID = Objective_tbl.GoalId
GROUP BY Client_Tbl.RegNum, Client_Tbl.Last, Client_Tbl.First, Goal_tbl.Goal, Objective_tbl.Objective, Objective_tbl.Objective_notes, Objective_tbl.Addnote;
Any ideas before I throw my self from my office.