Presentation Issue with 3 Forms Opening on DB Initiation

[disnrub]

I have a database my office uses to track cases. I had it opening to a Navigation Form, which had 3 other forms on it (CROLOG Input, CDI Input, and Reports.) My new boss wanted the input forms filtered to show only open cases. As the Navigation Form is not linked to a table or query, the filter could not be applied to that form. So, I filtered the input forms directly, and built a macro to open all three forms when the database is opened.



My problem is I want the form tabs to appear in the order above (CROLOG first, CDI second, and Reports third, as that is how the office has been viewing the DB since inception), and have the CROLOG Input form the one that is initially visible. In the macro, if I put the OpenForm commands in that order, the Reports form is the one visible. Is there a command I can add after DoCmd.OpenForm "Reports" that will then "click" back to the CROLOG Input form? (I’m just trying to make this update as seamless for the office as possible.)

[RuralGuy]

Selecting any control on the tab you want will pop that tab open for you.

[disnrub]

I am not a programmer, so am using the Macro Action Catalog. The only command I see that seems relevant is “GoToControl” with the definition, “Moves the focus to a specified field or control on the active datasheet or form.” Since the CROLOG Input is not the active form, I don’t know how to make it work. I do know how to convert the macro to VB, so could insert the line of programming I need if you could tell me what it is. Thanks for your help!

[RuralGuy]

Every control on *all* the tab pages has a unique name. Just select the name of a control on the tab you want with the command you found and it should work. If not, just post back and we'll get it to work.

[disnrub]

So, I was making this way too complicated. All I had to do was add another step in the macro to open the Crolog Input form, which brought it to the front. But, thanks for your help anyway!

[RuralGuy]

Excellent! Glad to hear you got it working.