Show Blank Form on Open

[NadiaVKhan]

Hello

I have a Form that is based on a Query. On this Form, I have a Field and Button and filters and me.querys the Form. However, when I open the form, it automatically displays ALL data from my query. How do I make my form display No data on load?



Thanks

[andy49]

Any help?

https://access-programmers.co.uk/for...d.php?t=110652

Or on the form_open event add

DoCmd.gotorecord, , acnewrec

[NadiaVKhan]

The link did not help.

Also, I am using a continuous form. So the DoCmd.gotorecord, , acnewrec does not work

[Missinglinq]

Set the Form's Data Entry Property to Yes, in the Properties Pane (Properties - Data - Data Entry) and then, in the OnClick event that starts the filtering process, have the first line of code be

Me.DataEntry = False

Now, you have to understand that when the Form first opens, this is going to show one blank Record, with nothing else showing except the background color from that Record to the bottom of the Form. You cannot show multiple 'empty' rows in a Continuous Form; they show a row-per-Record, plus a row for entering a new Record.

Linq ;0)>