Solved Returning to a Filtered Form (1 Viewer)

[Odeh Naber]

Hi everyone!

I have a series of forms in Access:

1. A list of commodities (e.g., Fanta, Coca-Cola).
2. A form displaying specifications for the selected commodity (e.g., 30cl glass bottle, 1lt plastic bottle).
3. A form showing market prices for the selected specification.

When I click "Back" on the market prices form, I want to return to the specifications form with the commodity filter still applied and the commodity name displayed in the title label. I am unable to get this to work.

To simulate what I am trying to do, it is best to check the attached file:

- At the login screen use the credentials admin@admin.com (password: admin).
- At the dashboard, on the left sidebar navigation, click on the 4th icon from the top left.
- Then click on the 'view' button next to any commodity.
- Then click on the 'view' button next to any specification.
- Then click on the 'back button' at the bottom left of market prices form (this is where I am having issues).

Thanks in advance!

 

[arnelgp]

try and test this.
there are some codes and Tempvars i added so you just follow your code.

 

[Gasman]

Hide the initial form and reveal it when you go back to it.

 

[Odeh Naber]

try and test this.
there are some codes and Tempvars i added so you just follow your code.

Thank you! This worked! I did try working with tempvars but apparently I was using it wrong.

 

[Odeh Naber]

Hide the initial form and reveal it when you go back to it.

I did this initially, but I thought it would not be so optimized having loaded forms hidden in the background. But thank you for the suggestion!