Hi,
Is it possible to create a button in a form and then add codes to it and when clicked it updates an exsisting macro ??

Example:
I want to import an excell sheet, of course i have to use a macro, however, could i create a button that when clicked it updates the macro details like change the oath of the excel sheet ?

try using a module (VBA) instead of a macro. Macro's are much too limitted...

Regards

Ok thanx..

You know how ??? the problem is i never used modules. I have always worked with macros

:confused:

Try searching the forum... many a sample out there...

Try this search (http://www.access-programmers.co.uk/forums/search.php?s=&action=showresults&searchid=237116&sortby=lastpost&sortorder=descending) for starters...

Regards