I have a button on the main form does several processes. Part of the
process is to see if the user exceeded their purchase limits. The DBA
has provided a scalar-valued function (dbo.POLimitGetFromEmployeeID)
that returns a decimal based on the userid that is passed into it.
The parameter for the function is @emp_id. Below is the IF statement
line that would use it.

If Me.Subtotal.Value > "scalar-valued function result goes here" Then

Never had to use/call one of these before. Been googling but I am
finding very limited information. How does one go about calling a
scalar-valued function in access07 to get the return value?

Thanks.
John

The only way you'll be able to call a SQL Server function in Access is if
you're using a pass-through query.

"John" <(E-Mail Removed)> wrote in message
news:94305859-4223-4575-8453-(E-Mail Removed)...
> I have a button on the main form does several processes. Part of the
> process is to see if the user exceeded their purchase limits. The DBA
> has provided a scalar-valued function (dbo.POLimitGetFromEmployeeID)
> that returns a decimal based on the userid that is passed into it.
> The parameter for the function is @emp_id. Below is the IF statement
> line that would use it.
>
> If Me.Subtotal.Value > "scalar-valued function result goes here" Then
>
> Never had to use/call one of these before. Been googling but I am
> finding very limited information. How does one go about calling a
> scalar-valued function in access07 to get the return value?
>
> Thanks.
> John
>
>