Remove rows with all zeros

[vrmomo]

I created a subform from a table and when I view it I have a row with all zeros. I tried everything, but I can't seem to remove it.

example

Name Price Unit
Apple $0.50 3
Orange $0.35 5
0 0 0 <----- I want to get rid of this

 

[Liv Manto]

Change the recordset of the subform to a query instead.

Design form of the form, click on the left corner box, click on record Source, create a query filtering out the zeros.

 

[Pat Hartman]

If your form allows records to be added, you may be looking at the "new" record that is waiting to be created.

 

[Liv Manto]

Oh yes, Pat is right. (as usual)

If the 0s appear at the end of the recordset, you can go to properties then data entry = no, allow additions = no..

 

[vrmomo]

lol....3 month later I have the same problem again. Oh and uh forgot to thank you guys.

THANK YOU!