Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004

    Question Unanswered: Open Form on same last record

    My main form has some cmd button for user to open "frmReport" "frmSearch".......when using this command button for example "frmReports" the main form closes and then opens the frmReports correlating to the button. when that form is closed the "mainform" opens up again but at the first record. Then the users have to re-navigate to the record they need.

    How can i go back to the record user were on after they close the "frmReports" ?

  2. #2
    Join Date
    Dec 2002
    Préverenges, Switzerland
    how about something stupidly simple:

    Me.visible = false
    when you zap to "frmReport" "frmSearch"


    forms!mainform.visible = true
    in the _unload() of "frmReport" "frmSearch"

    currently using SS 2008R2

Posting Permissions

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