>I am using on all forms only the current record selected that will need to be "moved" and updated 1 record at a time. I hope this helps and I greatly appreciate everyones help and input, when I deliver this program I am definitely becoming a member.
>
>Thanks again,
>

Hi Fred,

I think in your case you better go with Hilmar's suggestion of scatter and delete after locating the proper record.

>Also is there a way with the combo/text boxes to have the data be able to be selected and then autofill the corresponding field, for instance combo box produxctid and text box productname where productname would autofill from the same lookup table
>

I think you may check Downloads section here using Autofill in the title. There are a few autofill combobox classes but I haven't tried any of them personally.
>