No records unless sorted?? 1

[Recordsetclown]

I am trying to re-design a form that previously used radio buttons to filter the records displayed. I have removed all the filter code, but the modified form opens with no records displayed. However, if I select sort from the menu options, all records become visible and the modified form works as it should from that point on. How can I get it to open with all records displayed? Thanks.

Jeff

 

[tEkHEd]

do you have a me.visible = false code in the OnOpen event procedure?

 

[Recordsetclown]

No, nothing like that.

 

[judgehopkins]

On the On Open event procedure for your form, insert the following code:

Private Sub Form_Open(Cancel As Integer)

    DoCmd.ShowAllRecords

End Sub

Judge Hopkins

"...like hunting skunks underwater...."
John Steinbeck, The Grapes of Wrath

 

[Recordsetclown]

Thanks very much!! This took care of the problem.

Jeff