how do i stop records being shown on form load up?

[hardrock]

Hi all, i have a search function on my form, and the search will filter the records i have from a table when i click the ok button. This works ok, however, problem is, when i load the form up, the page is filled up with records? how can i show no records when the form loads up. Thanks

 

[spasticus]

off the top of my head you could try a couple things.

1. filter the form onload - if you filter the form by a value you know doesn't and will not exist you will get a blank, new record.

2. don't define a recordsource until the user clicks the "Search" button - you'll have to define a recordsource before any of your search code.

im not sure if there's an easy way to do it but thats what i'd do.

 

[Epic]

... and manipulate the filter by replacıng the record source... thıs will stop the user to cancel the filter... if you want