I have a form that is a search form to filter results and open another form to display the results. Things work fine when I'm comparing entered values to columns in my table, but now I'm trying to add a little more functionality and running into trouble.
On my form that is displaying the data, I have a calculated field (a number). I want to add a search criteria that says... If calculated field is > "entered_value" Then ...
What I can't figure out is how to reference the calculated field in Visual Basic. When I did dates I just referenced the column, but since this calculated field doesn't have a column (and from what I have read I should not create a column to store it), I can't figure out how to reference it.