Recent content by Ramrod

Not free... but pretty darn close for what it does. I have been using this for the last five years. Best intuitive help authoring tool I have ever used. http://www.helpscribble.com/

On your main form, try using the 'afterupdate' event on the field where you change your paramenter to do your requery.

Unless there is an overiding reason like "because I'm the boss and I don't want to do it that way...", Why not just add a 2 new fields to your original table? A Termed(y/n) swith and TermDate. To show active records, Termed(y/n) = False in all queries,reports, etc. After 2 years, run a delete...

I have not used this, but ran across it a while back. See if this is what you are looking for... http://www.mvps.org/access/api/api0008.htm

http://www.mvps.org/access/modules/mdl0055.htm Take a look at this link. I have several databases that I need to know who is logged on, this has helped alot.