DLookup error handling
Posted on 2002-07-29
I have a form that takes an order number. I am taking that order number, and using it to grab certain values within a table, as follows:
dlookup("FieldNameHere", "tableNameHere", "val1 = " & orderNumberFromForm)
but if the order number from the form is actually bad data, it throws an error and quite the entire application. Im wondering if anyone knows a fix for this, or perhaps a similiar function to dlookup that isnt quite as testy to work with?
The entire purpose of this is i need to get the total value of certain fields in the form. So if i enter order number 1, and it has 5 records related to that order, i need to find the total value of the price field within that particular order. I played with sum and dSum as well, but apparently im dim, cause i cant get anything working heh heh.