Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Location
    Minneapolis
    Posts
    21

    Question Unanswered: Find Record Macro argument suggestions

    I need to add a "find what" argument to a find record Macro that allows me to enter the criteria each time I search and search all fields in a table.. The Macro will be a command button to search all fields for the entered info. Any ideas???

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    465
    "I need to add a "find what" argument to a find record Macro that allows me to enter the criteria each time I search and search all fields in a table.. The Macro will be a command button to search all fields for the entered info. Any ideas???"

    You can do something like this:
    MyFind is a combo box


    Private Sub MyFind_AfterUpdate()
    Dim Valor As Variant

    Valor = Me!MyFind
    If IsNull(Valor) Then
    MsgBox "Must enter an Item", vbInformation
    GoTo Fin
    Else
    FindItem <------------------- This is a Macro
    End If
    Fin:

    End Sub
    Saludos
    Norberto

Posting Permissions

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