I have a sub-form that makes use of a right-click popup:
The properties of the sub-form:
In the code sheet of the sub-form:
Code:
Public Function ClearSelects()
'*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*
' Clear all the selected entries
'*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*
Me.Recordset.FindFirst "[RoomSel] = ChrW(9658)"
While Me.Recordset.NoMatch = False
Me.RoomSel = " "
Me.Refresh
Me.Recordset.FindNext "[RoomSel] = ChrW(9658)"
Wend
Me.Recordset.FindFirst "[RoomSel] = Chr(32)"
End Function
Clearly the function exists as public and within the scope of the sub-form right-click action, so I can't figure out why Access can't find the function. (I use this selection technique often, but this is the 1st time I've used it within a sub-form. (See screenshot example below)
What am I missing?