And actually to unselect everything / set value to null as if the form was just opened, what is the code?
Thanks
And actually to unselect everything / set value to null as if the form was just opened, what is the code?
Thanks
Think maybe union a (None) option into the comboboxes RowSources and modify function code like:Then could also have a button Click event that would set both listboxes to the (None) row and null the combobox.Code:If lbo.ItemData(item) <> "(None)" And (If lbo.ItemData(item) = varValue Or lbo.ItemData(item) = "(All)") Then IsSelectedVarClients = True Exit Function End If
Might also need to requery the form: Me.Requery
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.