How do yout prevent a form from getting order by hard coded?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey all, I have a form that is used on average by about 10 people on a daily
basis, who all like to see various sortings of the same information. Even
without saving somehow, soring gets 'hard coded' into the form itself (when
you go into design mode and go to form properties under the Data tab 'order
by' has a sorting filter in it). How do I prevent this line from being
populated short of turning off sorting?
 
on like an on close event? I already do that in the macros that close that
form, the main problem is, is when someone sorts and just closes the database
down. How do I make it preventing from there? and what code of line would I
use since you cannot use acsaveno by it self?
 
acSaveNo is an argument for the Close method. You need to use this to close
your form. Change the names where needed.
DoCmd.Close acForm, "MyFormNameHere", acSaveNo
 
Unfortunatley, when someone is on this form, sorts it, and closes the
database, for some reason the sorting gets saved. I have always had the
acsaveno when closing the form...
 
Back
Top