How to edit records in a table?

[A10 Instructor]

Hi, I'm new to access and seem to be running into a problem.

I have a table called personnel. Each record conatins their rank, last, first, MI, and duty position. I'm having trouble setting up the process to select an individual within the table, showing the current data in the applicable fields, then editing that information. Can anyone provide some help?
Here is my path in the database. After selecting the Personnel Options on the switchboard, the personnel options form is displayed. From their, I select the edit personnel button. A new form is displayed with a combo box that list's all the personnel entered into the table. I select a person to edit and depress the edit button. The edit personnel form appears, but it only displays the first record in the table even though I picked someone else.

Any help would be appreciative

Thanks

 

[Christopherusly]

I have a similar thing running on my database, do you want to post your table and form so i can have a play please ?

All solutions shall be posted back as a database,

 

[Pat Hartman]

You need to supply the correct value for the link criteria field used in the OpenForm method. The value will look like a where clause without the word "where".

 

[A10 Instructor]

I have a similar thing running on my database, do you want to post your table and form so i can have a play please ?

All solutions shall be posted back as a database,

Christopherusly,

Thanks for taking a look and trying to help me out, I greatly appreciate it. If you comne up with any suggestions, please don't hesitate to voice them.

 

[A10 Instructor]

Sorry about that Christopherusly,

I seem to have problems posting the table and form. Can you give me pointers on how to do that?

 

[WayneRyan]

A10,

Something like this for the code on the Button:

DoCmd.OpenForm "EmployeeForm",,,"[EmpID] = " & Me.EmpID

Wayne