Sort Form by text box

[Guest]

I am designing a form that has a combo box that looks up a customer number and a text box that displays the customer name (data pulled from the combo box and not stored a second time). Upon opening the form, I would like to run an event procedure that sorts the records by the text box, as if I had clicked on the text box and clicked the sort from a-z button.

When I go into form design, and type [Event Procedure] on "On Open", what code should I input?

 

[PC Datasheet]

You don't need any code! Just base your form on a query that is based on the
table and set the sort to Ascending for the field that the textbox is bound to.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

I am designing a form that has a combo box that looks up a customer number and

a text box that displays the customer name (data pulled from the combo box and
not stored a second time). Upon opening the form, I would like to run an event
procedure that sorts the records by the text box, as if I had clicked on the
text box and clicked the sort from a-z button.

When I go into form design, and type [Event Procedure] on "On Open", what code should I input?