Update Record

[fi.or.jp.de]

Hi All,

I have created UserForm in Excel and added button which will search
all the records in Access database and get the results in a Excel
userform listbox.

I dont have any problem in searching and updating the data into Access
Database.

The main problem is - Assume I have two textbox in userform 1. Name 2.
Dept

Using search option i will the results of all the names and dept in a
listbox.

Suppose user wants to change his dept then user selects particular
name in a listbox and will
change the name and if user updates the changes in my database I can
see old data and the new data.

I want only the new data.

Is this possible,

Please help me !

Thanks in advance

 

[Mark A. Sam]

If you are asking to see changes in the listboxes then in the AfterUpdate
event of any textbox which is updated, enter Me.Refresh. That will update
listboxes and comboboxes.

God Bless,

Mark A. Sam