Run vba code from within 2010 Data Macro

[TimTDP]

Is it possilbe to run a VBA function from within a 2010 Data Macro.

I have a function called WhoAmI with returns the Id of the user

I want to run this function from within the data macro.

 

[Banana]

If you're doing this in a client database, you can "cheat" by invoking a query that calls the VBA function... have a query do this:

SELECT WhoAmI()

then do a LookUpRecord.

If this is for a web database, however, this won't work.