Access03 form does not display records on open

  • Thread starter Thread starter Curmudgeon
  • Start date Start date
C

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
 
Sounds like you may have the Data Entry property of your form
set to Yes. If so, change it to No.
 
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
Click to expand...

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.
 
Back
Top