Filter a table without paradox autofilter?

[darlek]

I need to filter a table frame on arrive ONLY .
the paradox auto filter filters the table as a user imputs new data, and this is giving users problems.

I tried
if myfield.value<1 then
record.hide()
endif
I get an error and haveing tried various different ways i can't find the solution.

thanks for any help.