Remove RowSource from listbox when form closes

Question

In my Form Close event I have the following code. Problem is that it does not remove the RowSource. Am I missing something?

Private Sub Form_Close()

[Forms]![frm\_Navigation]![NavigationSubform].[Form].[Form]![lst\_Club].RowSource = "" 

End Sub

Answer 1

Actually did not reject them I had just posted and saw the second reply. In investigating that solution I realized that while I had removed the rowsource in design view without giving it enough thought after opening the form, I was right clicking on the form and going back into design view without going back to the listbox and removing the rowsource.

Answer 2

But, did you TRY them before rejecting the suggestions....

Answer 3

Not sure that's he way to go in my case. This database uses SQL Server as the backend and the form is populated from a Pass Through query to an SQL Stored Procedure. I run the Passthrough query when the form opens and then set the RowSource for the listbox. The problem is that if the RowSource is not cleared when the form closes, the next time it opens I get an ODBC error.

Answer 4

Alternatively, leave the Row Source of the list box empty in design view, and set the Row Source in the On Load event.

Answer 5

Have you tried saving the design change to the form before closing it?