Auto Month in Series

[sohailcdc]

Hi there
I am not sure, but I usually try to learn access during my free time and I usually play at unfound form level, no table nothing

Being an Accountant I usually try to create the different forms based on accountant requirements during my free time

I am trying to develop a form in the light of budgeting, therefore, I am designing a form with all possible options being an accountant I can think (it just a try nothing else)

Now here's the scenario
Fiscal Year
Period
Month
Working days

Period - Month - working (are my heading)
1 - Jan - 22
2 - Feb - 18 and so on

This is what I am trying to learn, if I select period 1 "Jan", application/code fill -out remaining months automatically, e.g. Period 2 "Feb"; Period 3 "Mar" .....

and if I select Period 1 "Mar", then period 2 "Apr", Period 3 "May" ......

Currently, I am using combobox, but problem is, if I selection period 1 = "Jan", then I am unable to restrict period 2 using "JAN" as both combobox are separate

Hope I can explain the situation

Any idea how, this can be handle

Thanks in advance and have a good day

 

[jdraw]

Instead of trying to invent some scenario using your understanding of concepts and an unbound form, I suggest you work through some established tutorials.

For Access or any database, one of the first tutorials should be Database Principles and Normalization Concepts.
http://forums.aspfree.com/attachment.php?attachmentid=4712&d=1201055452

To put some theory/concepts into practice see
http://www.rogersaccesslibrary.com/Tutorials/Entity_Relationship.zip

Getting tables and relationships designed to support your business facts is fundamental to database.

Once you are comfortable with concepts, see martin green's site for many tips and techniques tutorials at
http://www.fontstuff.com/access/index.htm

Good luck.