Returning a Value back from an MS Access Function in VB Script

[yamyam]

I am trying to use the returned code from a function in MS Access to determine what futher events i need to act upon with my vb script code.

set accessapp = createobject("access.application")
accessapp.run "GetCurrentPrice"

GetCurrentPrice returns the current price of an item

if > 50 then
....
endif

 

[PHV]

Like this ?
myCurPrice = accessapp.Run("GetCurrentPrice")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886