Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

bookmarks in form.

Discussion in 'Information Technology' started by Stefan, Jul 28, 2006.

Tags:
  1. Stefan

    Stefan
    Expand Collapse
    Guest

    Hi,

    I have a subform with an enormous list of properties according to projects
    that was selected in an second form. This works fine.

    Because its a great list (this has to stay this way) i want above it a
    listbox with the different chapters so that the user can click on the chapter
    he/she wants to see.

    My question is: is it possible to scroll a form using VB or something like
    bookmarks in WORD or FrontPage.


    --
    thanks,
    Stefan
     
  2. Loading...


  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    A bookmark in Access is a placeholder, similar to a placeholder in Word, but
    it doesn't use a physical place in a document. Rather, it uses a placeholder
    in a recordset.

    So in Access, you'd use the Key, or Index. Something like:

    With Me.RecordsetClone
    .FindFirst "ID = " & Me.txtID
    If .NoMatch Then
    MsgBox "Not found."
    Else
    'Go to the record.
    Me.Bookmark = .Bookmark
    End If
    End With
    End If
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "Stefan" <123@abc> wrote in message
    news:7F869E6F-905E-42C1-BD96-E25F845030CA@microsoft.com...
    > Hi,
    >
    > I have a subform with an enormous list of properties according to projects
    > that was selected in an second form. This works fine.
    >
    > Because its a great list (this has to stay this way) i want above it a
    > listbox with the different chapters so that the user can click on the

    chapter
    > he/she wants to see.
    >
    > My question is: is it possible to scroll a form using VB or something

    like
    > bookmarks in WORD or FrontPage.
    >
    >
    > --
    > thanks,
    > Stefan
     

Share This Page