Search results

There are a few different ways to do what want. At this point, with the form already created, the simplest would probably be to set the pricing fields 'Control Source' property as a DLookup. Something like: =DLookUp("[Price]","Products","[Product] = " & [Forms]![Form Name]![Product]) See the...

I was afraid of that. SQL is my weakness. I have almost no experience with it. I'd considered DSum. However, it seemed too limited for my purposes. The code in my first post was only meant to be an example of my problem. But, as I'm trying to code this as a function that can later be used in...

I'm creating a user-defined function. As part of this function I need to sum the total values of a field, [Qty]. However, I can't figure out how VB sums values over multiple records. The following code produces an error message "Sub or function not defined." Dim intResult As Integer Dim vrQty...