working with forms names

[basilyos]

hello guys

i have an idea i hope there is a solution for

i have 10 forms named

FormA - FormB ------ FormJ

i want to choose the formA and from a combo i want to choose a day so when this day come the chosen form will open automaticlly in the specified date when i open the database

for example i choose FormA and for the date i choose 9 or monday

so every 9 of any month the form will open or every monday

any solution???

 

[JHB]

Why do you want that?

 

[basilyos]

well actually from these forms i should print many reports so in reality i have more than 50 form and more than 100 report to make sure all the reports is printed a the specified date i want to make this

N.B: i could write this in VBA but unfortunately the date of reports may change so the client cannot change the vba

all he can do is open a form and choose the form name and the date

is there any solution??
or it's impossible

 

[Gasman]

PMFJI,

I would make this data driven by having a table that holds the form name and date to be opened. Then in the startup form of the database, open any form with the current days date. How you populate that table is up to you.

One solution anyway.

HTH