Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Go to record (Access 2000)

    How can i go to a record in the single form? I can go to the control productid with the command DoCmd.GoToControl "productid" . How can i go to the record productid = 13?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Go to record (Access 2000)

    You can use code like this:

    Dim rst As DAO.Recordset
    Set rst = Me.Recordsetclone
    rst.FindFirst "ProductID=13"
    If rst.NoMatch Then
    Beep
    Else
    Me.Bookmark = rst.Bookmark
    End If

    This code could be in the On Click event of a command button, for example.

  3. #3
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Go to record (Access 2000)

    Thank you so much !

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •