Firtst I need to thank Wayne, Pat and everyone on this board for taking the time to assist me with my sorting issue. I now have that solved.
My problem now is adding records to "frmPersonnelInput". Initially I did all my input directly into the table. Now have built a form to make adding new personnel, or making changes easier. When I try to add a new name I get a pop up box that says "Field cannot be Updated" I also found out that I cannot make changes in 'tblPersonnel" that will update in the corresponding "tblSort" for rank and battalion even though everthing is linked in relationships. I think this should be very easy but I seem to be missing a step. Thanks for you time. I have attached a copy of the database if anyone would like to take a peek.
Mike
Firefighter
Sparks NV
My problem now is adding records to "frmPersonnelInput". Initially I did all my input directly into the table. Now have built a form to make adding new personnel, or making changes easier. When I try to add a new name I get a pop up box that says "Field cannot be Updated" I also found out that I cannot make changes in 'tblPersonnel" that will update in the corresponding "tblSort" for rank and battalion even though everthing is linked in relationships. I think this should be very easy but I seem to be missing a step. Thanks for you time. I have attached a copy of the database if anyone would like to take a peek.
Mike
Firefighter
Sparks NV