Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    13

    Unanswered: Question on passing filters

    I'm trying to open a form from my current form with the same filter applied to it, the code I'm using is:

    DoCmd.OpenForm stDocName, , , Me.Filter

    This works except it does not include any sort filters.

    Is there another way of opening a form from another form using the same filter.

    Thanks,
    Mike

  2. #2
    Join Date
    Dec 2003
    Posts
    13
    Solution:

    DoCmd.OpenForm stDocName, , , Me.Filter
    Set Forms![calibration sheet].Recordset = Forms![Task Request].Recordset
    DoCmd.GoToRecord acDataForm, "Inst Report", acGoTo, Forms![Task Request].CurrentRecord

Posting Permissions

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