In VB access, I'm filling a combo box with a function instead of a query. I can't put a default value because the combo box is actually filled after the LOAD event of the form. Is there any way I can put a default value to my combo box ? If yes let me know.

Secondly, I would like to know if there's any way to get the application path in VB access ? The curdir function just give me c:\My document which I really don't care about. I would like to know from Where the MDB file has been opened so I can save an excel report there. Any idea ?

Thanks in advance

Nic