How Do I: Auto Select NavigationButton?

[RichardAnderson]

Hello guys,

I have what I am hoping is something very easy. In fact, I am really hoping this is just a properties setting.

I have a single row navigation form called 'Completed'. When the Completed tab is clicked (selected), a 2 row navigation form is shown. The top row is years and the bottom row is months. When the 'Completed' tab is clicked to show this 2 row form, it currently shows the first tab on the top row and the first tab on the bottom row. What I want to do is designate which top tab and which bottom tab is selected when it is opened. So today if it was opened, it would open to the top tab of 2013 and the bottom tab of Aug. The tabs that are automatically selected would change every month.

Any help would be great.

[RuralGuy]

Any chance you could post a picture?

[RichardAnderson]

Any change you could post a picture?

This first picture is the main form....


This next picture is with the 'Completed' tab selected.


You will notice that when you select the 'Completed' tab the tabs '2012' and Jan are automatically selected. What I need is to change the tabs that are selected when the form is open.
So... If it worked the way I need, then when you click on 'completed', then the tabs 2013 and Aug would be the ones to be open.

[RuralGuy]

Oh, *those* type on Navigation Forms! I've not been successful yet in dealing with them, sorry.

[pradeep.sands]

I haven't dealth with them till now...but I think reading the current year and month from system using the commands:
Year(Now)
Month(Now)
and then referencing these values to the names in your form to activate them would work I guess..use some command like bringtofront (see access help for exact command)..
this is just my thought..correct me if this is not the right method..

[RichardAnderson]

I haven't dealth with them till now...but I think reading the current year and month from system using the commands:
Year(Now)
Month(Now)
and then referencing these values to the names in your form to activate them would work I guess..use some command like bringtofront (see access help for exact command)..
this is just my thought..correct me if this is not the right method..

I tried putting Year(Now()) And Month(Now()) into the criteria but it does not work.

[RuralGuy]

If you want to post your db, maybe we'll play with it and all learn something about those Nav Forms.

[RichardAnderson]

If you want to post your db, maybe we'll play with it and all learn something about those Nav Forms.

It's too large.

[RuralGuy]

It's too large.

Even after you do a Compact and Repair and then ZIP it up?