Save the updated data

[ramindya]

Hello:



Attached is the application that I am working on.

The application has two list boxes and I am able to move the data from one list box to another list box which updates the data in the table (tblnames)
but it does not save the data permanently whenever I open the application it default sets the values to Yes to all the people in the ShowYesNoFilter field.

The add and remove operations are done through behind the form(please look at the viewcode).

Question/Issue: Whenever I reopen the application the changes that I made earlier -(the names that were moved to ListNoItems which also updated
the tblnames tables ) all got reset to Yes.Can you please let me know how to save the changes permanently?

Thanks,
Ram

[Bob Fitz]

Can you attach your file in mdb format? Some of us are unable to use accdb format.

[June7]

This line in the form's Open event runs a procedure that resets all the records to Yes.

ExecuteCommand mstr_SQLInstruction, mstr_Yes

Set a breakpoint on that line, use step debugging technique, follow the code as it executes.

[ramindya]

I changed the mstr_Yes in the Form_Open event to mstr_No and now it does not reset all the values to Yes and it works as I expected that is
changes that I made are saved permanently even after I re open the MS ACCESS database.

ExecuteCommand mstr_SQLInstruction, mstr_No

Can somebody good in VBA or programming can confirm me that my solution is correct ?

Thanks,
Ram

[June7]

If it does what you want then it must be correct. My question is why do you even need to call this function in the Open event? This function is called 8 times in different events. Does it work properly for all?