Question OrderBy

[bubba100]

Hi all-- Have a form bound to a table. The form has one text box. I am trying to have the info in the text box appear in order and the following code in the OnOpen event of the form asks for "Enter Parameter Value" of txtTypes. What have I overlooked?

Me.OrderBy = "[txtTypes]"
Me.OrderByOn = True

 

[HarleyQuinn]

How about:

Me.OrderBy = Me!txtTypes

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[PHV]

You should use a field name, not a control name.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[HarleyQuinn]

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[bubba100]

PHV you are correct again. Thanks FYI it should be the "." not "!

 

[HarleyQuinn]

Thanks for the tip, but it will work with both.

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.