Access03 form does not display records on open

[Curmudgeon]

I have a simple form based on a simple query. No records display when
the form is opened, but Records | Remove Filter/Sort on the menu bar
causes the records to display correctly.

I can find no combination of Me.Requery or Forms![frmName].Requery on
any of the form events (Open, Load, Activate) that will cause the
records to display.

I added a simple SendKeys statement to the On_Open of the form, which
causes the records to display, but I'd like a more robust solution.

Any suggestions would be appreciated.

Thanks
Dave

 

[Beetle]

Sounds like you may have the Data Entry property of your form
set to Yes. If so, change it to No.

 

[Curmudgeon]

Well, the fact that

Remove Filter/Sort

cures the problem of no records showing would suggest that the recordset is
being Filtered, maybe in the Form_Open or Form_Load event? I'd take a look in
the code behind the form. If need be, use Find and search for "Filter."

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200811/1

There is no filter specified in the form's property sheet, and there
is no filter reference in any of the form's events or app's modules.

 

[Beetle]

Did you check the Data Entry property of the form?