position to last record on a form from general module

[GraeagleBill]

The segment of code shown below is within a general module. I need a correct method to move to the last record on the referenced form. (I could do that with a another sort, but would like to know how to do it with a single statement if possible.)

If Screen.ActiveControl.Name = "tbGAPuse" Then     'Error 2474 if we're not on a control
    
    dteGAPuse = Nz(DLookup("GAPuse", "QLibrary", "WorksID = " & lngID))
    If dteGAPuse = 0 Then Exit Function


    Forms("frmLibrary").Form.Filter = "GAPuse = " & "#" & dteGAPuse & "# AND CatNo > 9000"
    Forms("frmLibrary").Form.FilterOn = True
    Forms("frmLibrary").Form.OrderBy = "AliasVolID ASC, VolPos ASC"
    Forms("frmLibrary").Form.OrderByOn = True
    
    Forms("frmLibrary").Form.LblFltrOff.Visible = True
    
    strFldrGAP1 = DLookup("CtlgNo", "QLibrary", "[WorksID] = " & lngID)
    
    Forms("frmLibrary").Form.DoCmd.GoToRecord , , acLast     '<<<<<<<<< This doesn't work
  
    MsgBox strFldrGAP1 & " " & Forms("frmLibrary").Form.RecordsetClone.RecordCount  'DEBUG ONLY
    MsgBox Forms("frmLibrary").Form.TitleExp                                        'DEBUG ONLY
    Exit Function                                                                   'DEBUG ONLY
End If

[Minty]

I don't think you can DoCmd against a form like that. Try something like

    DoCmd.GoToRecord acForm, "frmLibrary", acLast

[GraeagleBill]

BINGO!

Thanks Minty.

[isladogs]

As this code is only for form frmLibrary, why not put it in the form module instead of a standard module?
You can then use the Me. notation throughout e.g. Me.FilterOn=True

[GraeagleBill]

For right-click popup menus, Access can't find the Public Function unless it's in a General Module. I could create a general module transfer vector to get to the form's module, but since I have other functionality within the current module that needs to be in a general module, I chose not to do that.

[Micron]

Never heard of a module transfer vector. I do know that custom command bars always had to call a function as you say. Fore me, the sole purpose of those functions was to call some other procedure. That could be form module procedures if they were scoped as Public instead of the default of Private.

[GraeagleBill]

Sorry Micron, I sometimes forget that not everyone that programs these days has main-frame system backgrounds. Essentially, it's a fixed location in storage that tells all the system modules where to find the major system components, sort of akin to what you described as:

the sole purpose of those functions was to call some other procedure