I need help with an Auto Date issue in Access 08 Forms

[disney86]

I am setting up Forms in Access 08. I have a form which when opened will auto insert the current time and current date. I need to be able to allow the user to set up paramaters to auto select a future date based on the current date which auto populates.

This form will be used to print a traffic citation. The officer opens the form and inputs the values for offender information, vehicle information, etc. When the officer gets to the court date box, I want it to auto populate the next appropriate court date as defined in a agency setup process.

The problem I have is that this application will be used by multiple agencies. The agency will need to tell the application how they set up their court dates. Some agencies do court every monday for instance and some may only do court once a month on the third thursday. Anyone have an idea how I could set up a system of inputing these variables so that it can output a appropriate court date. Oh and just to make it even more thrilling to figure out, keep in mind that the rules they set up will also have exceptions such as blackout dates like holidays, etc.

Any suggestions greatly appreciated.

[Dököll]

Sorry for your troubles; you would however save yourself a lot of work if you posted part of or all your code here for looks. Most of us are just passing through, would jump to aid if code is available.

Do stay tuned though, I am not trying to be passive. I would also fetch through results here a little bit, just to see what's there.

In a bit, and good luck with your project-)

Actually, I have also taken the liberty of changing your title to see if you can get better hits on this,

changed from:

"I need help with an Auto Date issue"

to:

"I need help with an Auto Date issue in Access 08 Forms"

Also sending over to Access for added support.

In a bit!

Dököll