Navigational button?

[Lifeseeker]

Hi,

Would it be possible to have a button on a form that simply takes users to the previous form that was opened?

Users now have the option to look at all the tabs that were opened at the top, but if they open too many of them, sometimes it's harder to go back to a specific form.

Am I making sense?

Thanks

 

[boblarson]

Well, what tabs are users having at the top? Are they all different forms or something else? Just a reminder that users should not be in tables or queries directly as you lose control when they are.

 

[Lifeseeker]

Well, what tabs are users having at the top? Are they all different forms or something else? Just a reminder that users should not be in tables or queries directly as you lose control when they are.

Hmm let me think about this further, but thanks Bob.

Yes the people who are simply viewing the database will be using forms alot.

 

[missinglinq]

As Bob said, your post isn't clear as to exactly what you're doing here. If you're using command buttons to go from, say Form1 to Form2, Form3, etc, when you open the new form, you can send the name of the calling form to it, then use this in a 'return' button to go back to that calling form.

From the Calling Form

Private Sub GoToForm2_Click()

    Dim stDocName As String
    Dim stCallingForm As String
    
    stCallingForm = Me.Name
    DoCmd.Close
    stDocName = "Form2"
    DoCmd.OpenForm stDocName, , , , , , stCallingForm
    
End Sub

Then in the Form Called

Private Sub GoToPreviousForm_Click()

Dim stDocName As String
Dim PreviousForm As String
  
 If Not IsNull(Me.OpenArgs) Then
  stDocName = Me.OpenArgs
  DoCmd.Close
  DoCmd.OpenForm stDocName
 End If

End Sub

Linq ;0)>