Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2009

    Unanswered: Getting a form to find data and then clicking through to the main table

    hi - i have not been able to find this answer.
    i am using a split screen form and have 8 fields on the top. when i sort and come up with my list of results on the bottom, can i then select a line and somehow have it launch the main table that the form was created from and just to that data line in the table.

    any help is apprecaited. Kindly. jnr

  2. #2
    Join Date
    Feb 2006
    you could open the table with docmd.opentable and then use docmd.searchforrecord to get to your specific record. or create a query which you could open and then filter, so you only see your specific record. or you could have another form which is filtered and only shows the specific record.

Posting Permissions

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