Kehar,

You failed to mention what kind of database. Access, MySQL, SQL, Progress, Alpha, Oracle, Fox Pro?

However, for most of those it is as simple as having a lookup table to populate your combo box and to change the table your queries look to. BUT, for some things like triggers, stored proceedures, and such, this will make your job a little harder as you will need to alter those to either accept a parameter or to look up in your lookup table to build their functionality.

So, in short, for us to help you better we will need to know what is your backend.

Good Luck

Hi,
Oh sorry. I am using Access as backend and VB6 as frontend.
and using ADO connection.
Pl write comprehensive code for the problem.

(Kehar)

How much are you going to pay if we code your solution for you?

How about you take a look at post #12 in this thread...

http://www.codeguru.com/forum/showth...hlight=ado+dao

and do some work yourself!

Good Luck

Hi,

Its always a Good Idea To Create a Seperate Database for each Financial year. Just copy the existing database as new one using "FILECOPY" and clear tables ..

Regards
Veena