Access03 form does not display records on open Curmudgeon <ehtoya[ at ]gmail.com> 11/10/2008 6:32:43 PM 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

RE: Access03 form does not display records on open Beetle 11/10/2008 6:43:02 PM Sounds like you may have the Data Entry property of your form set to Yes. If so, change it to No. -- _________ Sean Bailey "Curmudgeon" wrote: [Quoted Text] > 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 >

Re: Access03 form does not display records on open "Linq Adams via AccessMonster.com" <u28780[ at ]uwe> 11/10/2008 6:53:55 PM 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.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200811/1

Re: Access03 form does not display records on open Curmudgeon <ehtoya[ at ]gmail.com> 11/11/2008 12:47:03 PM On Nov 10, 1:53 pm, "Linq Adams via AccessMonster.com" <u28780[ at ]uwe> wrote: [Quoted Text] > 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.

Re: Access03 form does not display records on open Beetle 11/11/2008 4:23:02 PM Did you check the Data Entry property of the form? -- _________ Sean Bailey "Curmudgeon" wrote: [Quoted Text] > On Nov 10, 1:53 pm, "Linq Adams via AccessMonster.com" <u28780[ at ]uwe> > wrote: > > 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. >

Re: Access03 form does not display records on open "Linq Adams via AccessMonster.com" <u28780[ at ]uwe> 11/11/2008 6:02:18 PM Never realized that, BB, but Remove Filter/Sort does cause a form with Data Entry set to Yes to convert it back so that all records can be viewed. -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200811/1