Ctrl PgUp/PgDn doesn't work ?

[ksor]

I have made a generel search form - showing persons and as I enter characters in a search field the set of records shown is limited to records where my entered chareactors are present - works fine !



I the search result - let's say - shows 7 records, the focus is by default on the FIRST record in the set but often I need to "go down".

I can do that by using Ctrl+PgDn and Ctrl+PgUp if I want to move focus up again - works fine - BUT ....

When I open this search form on top of another form with this code:

Public Sub Opslag(f As String, keyName As String, fo As Form)
    Dim frm As Form, gemId As Long, rst As Recordset
    onlyHide = True
    DoCmd.OpenForm f, acNormal, windowmode:=acDialog
    If CurrentProject.AllForms(f).IsLoaded Then
        Set frm = Forms(f)
        gemId = frm.Controls.Item(keyName)
        onlyHide = False
        DoCmd.Close acForm, f
        Set rst = fo.RecordsetClone
        rst.FindFirst fo.Controls(keyName).Name & " = " & gemId
        fo.Recordset.Bookmark = fo.RecordsetClone.Bookmark
    End If
End Sub

this Ctrl+PgDn/PgUp DOESN'T work - WHY ?

[davegri]

Form opened with acdialog behaves like a Modal form. Code execution stops until the form is closed.

[ksor]

????? should that stop the Ctrl-PgDn/PgUp functionality in the opened form ?

[davegri]

If I were you, I would try it and see.

[ksor]

Ha, ha, yeah. ofcause ... but what IS IT you would want me to try ?

I HAVE tried to
1) set the Modal property on the opened form to YES and NO - no difference !
2) set the acDialog to acWindowNormal in the opening CODE WITH Model set to both YES and NO in the opened form - result = the opened form just opens and closes again right away - just a short blink.

I don't think there is more combinations I can do.

and back to the problem - if I open the search form directly it all works fine with the Ctrl+PdDN/PdUp = the focus moves between records.

If I open the search form with the code I posted - with the changes in different combinations - the Ctrl+PdDN/PdUp-functionality is NOT working !

Obviously it has to do with the code I use to open the search form - but what other combinations can I use in the code ?

[davegri]

If search form is opened modal or acdialog, scrolling won't work. If opened normal, it closes immediately, right?
I think you'll need a button to close the form opened normal.

[ksor]

If search form is opened modal or acdialog, scrolling won't work. If opened normal, it closes immediately, right?
I think you'll need a button to close the form opened normal.

I don't any reasen why it shouldn't - what has Ctrl+PdDN/PdUp to do with modalism ?