Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Open /Search for next record (97 sr2)

    I created a form, based on a parameter query, that asks for the data entry person to enter the customer's name so it will pull up that person's record. Works great. However, if you want to enter another person's name and go to that person's record, how do I do that?

    I thought about creating a macro and then creating a button to run that macro, but that didn't work. I know NOTHING about VB code, so I'm trying to do all this without using code... unless someone can provide the code to me and tell me where to put it so it will run.

    Thanks!

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Open /Search for next record (97 sr2)

    Why don't you use a combo box to do the same thing, then you don't need the parameter in the query.
    The code to put behind the query is either an ApplyFilter or some code these kind lounge people supplied.
    Here is an example of such code:

    Sub FindCourse_AfterUpdate()
    'Find the record that matches the combo box
    Dim vFindCourseDim vCriteria As String
    'build criteria from combo box
    vCriteria = "CourseNumber = '" & "'" & Me![FindCourse] & "'"
    'find and bookmark matching record
    Me.RecordsetClone.FindFirst vCriteria
    Me.Bookmark = Me.RecordsetClone.Bookmark
    'reset combo box
    Me!FindCourse = ""
    End Sub

    HTH
    Pat

Posting Permissions

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