list of employyes and buttons

[JonatABS]

Ok I bet this question has been asked a million times but as im new here. Im gonna just ask away.

I have a subform to show a table of employees we have.

I first want to be able to select one of them employees and click a button to go to the form I have created to update his/her information.

I then want another button to click to delete that employee from the list.

IS that possible? Ive been doing Acces for a whole month so forgive me LOL

 

[Peter D]

Have you seen the Northwind.mdb example database that comes with Access? It has lots of good examples including an Employees table and form.

If you want to delete a record from a continuous form subform, you should be able to select it by clicking the record selector on the left, then by pressing the delete key.

If you want to refer to the current subform record primary key field then this the way to do it:

Forms!MyForm!MySubformControl.Form!MyPrimaryKeyField

To delete a record:

CurrentDB().Execute "Delete * from MyTable where MyPrimaryKeyField = " & Forms!MyForm!MySubformControl.Form!MyPrimaryKeyField

Hope this helps,