Listbox to open Variable form

[Ineedcoffee]

Hi All,

I have been trying to create a Listbox that has names of forms in it. I then want to be able to open the form that coresponds to the users selection.

It is based on Academic Years, so 07/08, 08/09, 09/10 and so on. When the user selects a Year I want it to (in the After Update) open the corresponding Form (I have created a Form for each year).

Can this be done? I have tried using the OpenForm command and instead of using a form name I have used the Temporary Variables name.

Any help would be fantastic,

Thanks,

Ineedcoffee

 

[Ineedcoffee]

Never mind, all fixed. All I did was put a condition in that was ([TempVarName]="AcademicYear") then used an OpenForm command to open the correct form.

Maybe this can help someone else who are a little simple like me


Ineedcoffee

 

[boblarson]

Your description of a form for each year makes me think you may have a normalization problem here. Do you have a table for each year as well? If so, then that is not a good design and will take way more to maintain than if it was done right. If that is not the case, then I wonder why you have a form for each year because you should be able to use the same form for any year (if your table structure is sound).

 

[Ineedcoffee]

Hi Bob,

Main problems I have with normalisation with the Industry we are in is that every year, the same field used on a piece of paperwork may have its criteria changed. This would then be a nightmare as when one code would have worked in a previous year, it may not this year.

I have thought about a number of ways that we could do this but to be honest, previous data is very rarely used (normally just for reporting purposes) so I think I will keep things as they are for now.

Just as a note, I only keep the last 4 Academic Years worth of data at any one time, I then store the old data in an archive database.

Hope this helps,

Ineedcoffee