Datasheets losing filter

[diego.gsantos]

Hello everyone!

It's my first post here,

I'm having a problem that is driving me crazy.

I have an aplication that is structured in this way:

Menu (navigation control) > Subform 1 > datasheet inside subform - lets call it "FORM A" (there are many forms like this one)

In one of these nav options, it's a little diferent with: Menu > Subform > Two tabs > 1 datasheet per tab, with filters in the datasheet - Lets call it "FORM B" (there is only one like this one)

The problem is:

When I sort the datasheet in FORM A (or others like FORM A), using the column header of the datasheet(using the checkboxes, no vba involved), then I go to another navigation option, access ask me "Do you want to save changes in design view of bla bla bla", if I answer Yes or No, the result is the same:

Access clean all the filters in the datasheets inside FORM B...

I already tried to "force" access to re-apply the filters by using vba in "On load" event of these datasheets, but it didn't work.

I realy don't know what is happening... Could you please give me a light in this problem? Thank you.

Diego

 

[EternalMyrtle]

Just set the sort order in the underlying queries for the datasheet.

 

[diego.gsantos]

Just set the sort order in the underlying queries for the datasheet.

Well, it don't solve the problem, as the user need to re-order it during the use...

I ended remaking all forms using continuous form instead of datasheet...
Thanks anyway :3

 

[EternalMyrtle]

I was going to suggest that next. I generally prefer continuous forms. Well, I am glad you solved the problem!