Filtered form opens with no record

[Guest]

I have a uneditable form which i use to select data to edit. Once selected it
opens another form with all the available fields on it.

It has recently started to come up blank.

If I press the remove filter button, all my records appear, then when I
press it again to apply filter - the record I originally wanted appears.

It has only just started doing this, any ideas??????????

 

[christianlott1]

It has only just started doing this, any ideas??????????

Nulls in your data set maybe.

It depends on what your filter criteria is and how specific.

Maybe your data is joined to another table that doesn't have the right
data in the right fields.

 

[John W. Vinson]

I have a uneditable form which i use to select data to edit. Once selected it
opens another form with all the available fields on it.

It has recently started to come up blank.

If I press the remove filter button, all my records appear, then when I
press it again to apply filter - the record I originally wanted appears.

It has only just started doing this, any ideas??????????

Please post your filter button code.

John W. Vinson [MVP]