Order By automatically filled in

[Jackie]

What causes the Order By property to be filled in on a form?

When the user employs the Access menu find option the Order By property sometimes gets populated. The form contains a subform. The value it is populated with references a form that no longer exists in the database.

How can I prevent the Order by property from being populated when the user employs the find option?

 

[Rolliee]

Order By is a property and does not 'populate.' I am not being picky - just want to know what your underlying question is. If you want to chnage the order to the order of the table under the recordset and you are in a form view, you can do a

me.orderbyon = false.

Rollie E

 

[Jackie]

My question is "Why does the "Order by" property get filled in after the user does a "Find"?

 

[Rolliee]

It doesn't "get filled" I am not at all sure what you are describing.

Rollie E

 

[Jackie]

When the user is in form view and uses the "Find" option, the next time the user enters the database and launches the form, an error message window requesting input for a variable is displayed. The variable references a form that is no longer in the database.

When this happens, the Order By property for the form gets populated. Any other time, this property does not have a value.

 

[Rolliee]

Jackie,

I just do not understand the phenominon that you describe as 'gets filled.' If you would like to send me a zipped sample, I will see if I can solve your problem.

rollie@bwsys.net

 

[Jackie]

I am having trouble duplicating the problem.

I will be in touch when I can get the problem to recurr.

Thank you for your help.