I have my list box on a form which displays "Jan-Dec", i have a function in place, and a button called delete. So im thinking a user selects the month from the listbox and then presses the button delete.
My problem here is my delete query is doing nothing!
When i run the delete query manually, i get the inbuilt box "Enter Parameter Value" get_glbMonthToDelete
I think im close but am missing a cruical step/link!!
I have attached a screen shot of my form
My delete query
Function get_glbMonthToDelete() As String
get_glbMonthToDelete = glbMonthToDelete
a module - Option Compare Database
Public glbMonthToDelete As String
Public Sub Command12_Click()
If Not IsNull(Me.List10) Then
glbMonthToDelete = Me.List10