Drop Down Menu to Select Linked Form

[JMarcus]

I typically have buttons and a macro set up which will link to the original form by primary key. Anyone built it with drop down menu?

For explanation when on Training Records Form for ID: 007 the admin can then open each year by a button for only ID: 007.

 

[pbaldy]

You don't have years in separate tables/forms do you? That would typically be a mistake. You would normally have year be a criteria. You can do what you're asking:

DoCmd.OpenForm Me.ComboName

but first thing would be to make sure the design is correct.

 

[JMarcus]

I would use a combo box with a drop down to select each form. Forms and table are already designed. All set to go I just need to add one combo box or list box to open each year.

 

[pbaldy]

Okay, so you're going to stick with the design, no matter if flawed. Your call. Like I said, you can have a combo with form names in it (you can have something friendly displayed to the user).

 

[JMarcus]

They are only in 1 table but each year is in seperate form. Doesnt sound like a flaw to me.

 

[JMarcus]

I think I found your code

 

[pbaldy]

Why a different form for each year? Does each have a criteria to filter for a given year? If so, why not one form, opened to the desired year?

 

[JMarcus]

Too many fields and check boxes per year would be too crowded and would not be clean.

 

[pbaldy]

Do you have fields like Something2014, Something2015, Something2016, etc? If so, also a common mistake. I guess I should leave you alone though; it's your baby.

 

[JMarcus]

Yes it is but I inherited the db. Im not going to change it.