Results 1 to 2 of 2
  1. #1
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 7 64bit Access 2003
    Join Date
    Feb 2011
    Posts
    1,606

    Missing "Public Function" not being found

    I have a sub-form that makes use of a right-click popup:
    Click image for larger version. 

Name:	ArCl2.jpg 
Views:	9 
Size:	82.9 KB 
ID:	24045

    The properties of the sub-form:
    Click image for larger version. 

Name:	ArCl1.jpg 
Views:	9 
Size:	56.2 KB 
ID:	24046

    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)

    Click image for larger version. 

Name:	ArCl3.jpg 
Views:	9 
Size:	126.5 KB 
ID:	24047

    What am I missing?

  2. #2
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 7 64bit Access 2003
    Join Date
    Feb 2011
    Posts
    1,606
    Function has to be in the parent form in order for it to be "seen".

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 09-07-2015, 08:00 AM
  2. Replies: 2
    Last Post: 11-12-2013, 07:06 PM
  3. DAO .Edit "Method or data member not found"
    By GraeagleBill in forum Programming
    Replies: 3
    Last Post: 09-05-2013, 02:10 PM
  4. Replies: 2
    Last Post: 11-04-2011, 02:45 AM
  5. "No Record Found" Function
    By viper in forum Programming
    Replies: 8
    Last Post: 02-09-2011, 09:52 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums