Share via

Do not reset form when using navigation buttons

Anonymous
2014-03-21T14:56:41+00:00

Hello, 

When using Navigation forms in Access, is it possible to keep from refreshing the form as you move between navigation buttons? Example: I have a query under button 1. when i move to button 2 and then back to button 1 i would want the view to be the same as i left it and not refresh when opening. I am on the upper end of an access beginner so i know some VBA code but not much. 

thanks

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

1 answer

Sort by: Most helpful
  1. Anonymous
    2014-03-21T15:26:50+00:00

    No.  What you're seeing is the way the Nav form works, it only has one subform control.  Switching tabs just resets the subform control's SoureObject property and that "opens" the form, query, etc. got the selected tab.

    To get what you want, use the Tab control so you can have separate subform controls on each tab page.

    Was this answer helpful?

    0 comments No comments