Editing table entry from Form

[tjb1]

Hello, I have a Form that is used for creating entries to fill a table. On the same Form there is also a list that shows everything in the table and a double click on the list will populate the Form with that data. The problem is that "Save Record" command button will not update the table because it thinks it is creating a new record.



The code to populate the form from the list is


Private Sub EmployeeEntryList_DblClick(Cancel As Integer)
Me![Number] = EmployeeEntryList.Column(0)
Me![EmployeeNumber] = EmployeeEntryList.Column(1)
Me![FirstName] = EmployeeEntryList.Column(2)
Me![MiddleInitial] = EmployeeEntryList.Column(3)
Me![LastName] = EmployeeEntryList.Column(4)
Me![Supervisor] = EmployeeEntryList.Column(5)
Me![Group] = EmployeeEntryList.Column(6)
Me![Shift] = EmployeeEntryList.Column(7)

End Sub


I'm not sure how I can make it populate the form if an entry is double clicked and then be able to save a modified version of that record over top the original. Thanks

[pbaldy]

If the form is bound to the table, you'd need to navigate to the record you want to edit first. Is one of those fields a key field that represents the record to edit?

[tjb1]

The number field is a key field since it is unique to each employee but it is not auto generated.

[June7]

Why are you saving all those data? Are you editing the employee record in Employees table? If you are populating another table with all that employee info - shouldn't. Save only the Number or EmployeeNumber, whichever is defined as the primary key field.

Use bound form and no VBA to save value is needed.

[pbaldy]

You aren't requerying, but you can adapt this to go to the specified record before copying values:

http://www.baldyweb.com/Requery.htm

[tjb1]

The form is bound to the table with all that data, there is a list on the form that displays the table. The VBA populates the form with the info from the table with the intention of editing the data which is where I'm stuck... The form also allows the addition of new data.

[June7]

Is this form BOUND to the table?

Use of ! as you have usually indicates reference to a field. If this form is BOUND and textboxes are BOUND to fields, this code is not necessary and is actually probably causing difficulty.

Here is one method for locating existing record for editing. http://www.allenbrowne.com/ser-62.html