Results 1 to 3 of 3
  1. #1
    P5C768 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Aug 2009
    Location
    Denver, CO
    Posts
    95

    Can you use a parameter in findrecord?

    I created a query based form that returns the result of a parameter. However, I would like the query based form to open another form and go to the record found in the query.



    I have been trying to use the findrecord action in a macro, without much luck. Any thoughts?

  2. #2
    P5C768 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Aug 2009
    Location
    Denver, CO
    Posts
    95
    Maybe I wasn't clear. I would like to find the easiest way to go to a specific record on a form using a parameter entered by the user.

    It is a pre-existing form, so I don't want to try and create a query based form. I just want to go to a record on a form based on user inputs.

  3. #3
    dcrake's Avatar
    dcrake is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    435
    Lets say the user has entered this value in a textbox on the initial form or it is the value in a bound control on the form. When you open the second form you can apply a filter to it. To do this go to your second form and go to the OnLoad Event of the form and enter the following

    Me.Filter = "FieldInFormRecordSource =" & Forms("FirstFormName")("ControlName")
    Me.FilterOn = True

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Criteria Parameter
    By djwasim in forum Reports
    Replies: 1
    Last Post: 07-04-2009, 08:22 AM
  2. Using parameter in autoexec macro
    By lchurch in forum Queries
    Replies: 0
    Last Post: 03-04-2009, 06:22 PM
  3. Enter Parameter Value
    By plesser in forum Access
    Replies: 1
    Last Post: 11-08-2008, 10:27 AM
  4. Date Parameter
    By shakira in forum Queries
    Replies: 2
    Last Post: 03-09-2006, 12:55 PM
  5. Add combo box to parameter query
    By louisa14 in forum Queries
    Replies: 1
    Last Post: 12-10-2005, 08:38 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums