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

    Unanswered: DoCmd.OpenForm question

    I want to open another form from my current form that shows all the records but makes the current record of the form opening equal to the current record to the form that is calling it...

    DoCmd.OpenForm stDocName, , , "[Primary] = " & Me![Primary]

    this code opens the stDocName form with only the current record.


    Thanks,
    Mike

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

    DoCmd.OpenForm stDocName
    Set Forms![calibration sheet].Recordset = Forms![Task Request].Recordset
    DoCmd.GoToRecord acDataForm, "calibration sheet", 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
  •