User Form - Data Input FOrm

[sue.Caradonna]

I have created a user form in VB. I have used text boxes and combo boxes so NEW data can be entered into a worksheet which appends and contains all entered information (data). All data is being successfully added through my user form.

However, now I need to develop a button for the user to select that allows the user to amend data that has already been entered into the database. They will do this by selecting the person's name (or typing in the person's name). The existing person'a data is then shown on the data input form so AMENDMENTS can been made to their existing details.

How do I do this? Also how do I create a button that allows the user to select the "previous" entry or the "next" entry.

Thanks so much for your help, Its really appreciated believe me, and you are making things so much easier to understand than the "text" books!

 

[Rupert Bennett]

Sue,
John Walkenbach (j-walk.com) has a free dataform add-in that could be used to accomplish this. I have also used another userform with the textboxes and comboboxes side by side. Have the left set of boxes show the existing data and the right set of boxes will be used to amend the data when you click a command button. The right right boxes should be coded to accept the values of the left boxes, if no changes were made. Post back if you need more help on this.
Rupert