Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2006
    Posts
    2

    Unanswered: Navigation using VBA

    I am in a continous form. I click a field name Serial. Code opens form called "frmDataEntry"

    But not only that, I want to land in the same record from the continous form. The field Serial is the index/key field.

    Private Sub Serial_Click()
    Dim rec As Integer
    rec = Serial
    DoCmd.OpenForm "frmDataEntry"
    WHAT CODE DO I NEED HERE TO LAND IN RECORD WITH SAME SERIAL
    End Sub

    Is there another way to do it?

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    In VBA help for OpenForm, look at the wherecondition argument.
    Paul

Posting Permissions

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