Filtering on a Form

[Keith S]

Using Access 2003, I have put a macro on the click field property of a field
on a form. The macro has the applyfilter command in it. In the where
option, I am prompting for data to search. For instance, if a user clicks on
the PO field, it prompts them for a PO number. If the filter finds the
prompted PO number, it brings the record back to the screen. However, if the
filter does not find a record for the prompted data, it brings back a blank
screen. The blank screen only has the Form Name in a label field, but
nothing else. How can I get it to bring back a record, preferably the
previous record if the prompted filter does not find a record?

Thanks for any assistance.