Hi All

I'm having a time with a form that I need to be able to add new records to.
Here's the sinario.

Form name: frmMyEmployeeMilestones
   Record Source: A query named qryMyEmpMilestones
   Default View: Single Form
   Allow Form View: Yes
   Allow Datasheet: Yes
   Allow PivotTable: Yes
   Allow PivotChart: Yes
   Allow Edits: Yes
   Allow Deletions: Yes
   Allow Additions: Yes
   Allow Entry: Yes
   Recordset Type: Dynaset
   Record Locks: No Locks
   Scroll Bars: Neither
   Record Selector: Yes
   Navigation Buttons: Yes

The query (qryMyEmpMilestones) is as follows
   SELECT EmpMilestones.MilestoneID, EmpMilestones.EmployeeAlias,
EmpMilestones.Year, EmpMilestones.Milestones, Employee.Department,
Department.DepartmentManager
FROM (EmpMilestones INNER JOIN Employee ON EmpMilestones.EmployeeAlias =
Employee.Alias) LEFT JOIN Department ON Employee.Department =
Department.Dept
ORDER BY EmpMilestones.EmployeeAlias;

When I run this form I get the nav menu at the bottom that allows me to
navigate through the resultset which in this case contains 16 records. But
it doesn't let me add a new record. That button is greyed out. So I added a
button and on the click event I created a sub to add a new record which does
allow me to insert a new one but it seem very much over kill. At one point I
was getting an error saying that I needed to use an Updateable Query.

So, I'm not what I'm missing here to make this work. Any help or pointers
from you all would be very much appreciated.

Bill