only opening records that meet a criteria

[libby32]

Hi, I have a calculated value based on a subform and form displayed on my main form. When this value calculates to 0, I don't want this record to show. Only the records with a remaining inventory (that is a value greater than 0)should show. How can I only show the records on my form with a value greater than 0??? I'm a beginner so sample code and where I should put it would be great help.

TIA

 

[skwilliams]

One way is to create a filter which would filter out anything not meeting your criteria.

Another way would be creating a query and specify the criteria within it. Then use the query as the record source for your form.

HTH

 

[libby32]

I tried both of these, but I'm still getting all records. The calculation is on the form.

 

[Rich]

Please don't post the same question twice