Form data updating wrong line

[Allilue]

Hello,

I have a form which lets me input data for a table. However, I'm not inputting NEW records, but rather replacing them. The first step is choosing a Name from a combo box. This is the record to replace. Then I have text boxes to fill in to replace existing data. When I select a name from the combo box, i'm not sure how to tie it to the rest of the information. For instance, I'll pick name ABC, which is a record in my table, then input a Date. However, the Date inputted into the form automatically goes into the Date field for the FIRST record, and not the one for ABC. HOw do I connect it so that all the input goes into the record of the Name selected?

Thanks!

 

[jagilman]

You will need to attach code to the after update event of the combo box where you select the record you want to edit. This will cause the form to jump to that record. Then when you edit any of the fields they will be for the correct record. Need help just ask.
John A. Gilman
gms@uslink.net