Form loses filter after design view.

[Moss100]

Hello I have noticed that my forms lose their filter / reference if I go in and out of design view.

Is this normal behaviour or is there a way round this?

For example I have several forms which run in a navigation control. They are all linked by primary keys. All works fine, but if I enter design view the form which is placed into design view reopens but is unfiltered and displays the wrong record

If I cycle through the other linked forms in the navigation control they work fine and pick up the right records, it's just the form which entered design view that remains with the incorrect record.

Closing the navigation control and opening it again puts everything back in sync, but it's just a tad annoying

Thanks mark.

 

[LaurieHamlin]

I'm not sure why you would change to design view when using a form? If you're still creating the form and want the data to remain filtered while you create it, then off the top of my head here are a couple of options:
1. create a button on the form and put in the code

DoCmd.close
DoCmd.OpenForm "formname

"
When you've finished creating the form, delete the button.
2. create a query to filter the data and use the query as the data source until you finished, then change the data source back to the table.

It would also be helpful if you post the versions you are using.
I hope that helps.