I have a form that is used to update a few pieces of data from my master table. To simplify things down a bit, when I open this form, I only want my data to show for records where "Remaining $" are greater than $0. So far, I haven't discovered any way to successfully do this.
1. When I look at the properties for the form, I have a line of code in the Filter box (under the Data tab) that reads ((Not MasterInfo.[Remaining $]=0)). I can't remember where this comes from, but apparently it doesn't work.
2. I also tried creating a macro that applies a filter where I built an expression that essentially states the same thing as point 1 above. I put the macro on the form properties under Open. However, when I opened the form, it showed 1 data row with zero values all the way across. Perhaps the code was wrong, but I should have about 800 rows of data.
3. I guess the long way to do this would be to create a "make-table query" that pulls all the data greater than zero from my master table. I could then use a form to update this temporary table, and then run an update query to take data from my temp to master table. This seems like a bit of overkill to me (if it would even work).
I imported the filter buttons in to my design view, but they aren't applicable there. Any idea how to filter this report other than the standard option (i.e. right click in the field to filter and use Exclude filter)?
See below for a sample view of the database (click it).