i have an access database .accdb, I want to call a sub SetDate when the database is starting. I can not find this information in the access vba help. It is very simple in Excel but not in access.

Could someone please help me how to do it?!

You need to call that Sub in a function. After you complete the function, then you need to create a macro that calls that function. Name the macro AutoExec.

When you start the MDB, the AutoExec will fire and call the function. The function will call the sub.

__________________
Greg Serrano
Michigan Dept. of Environmental Quality
Air Quality Division