a-z sort for control button

[darklite]

I'm trying to figure out how to set a control button that will permit me to do an a-z sort on a form. I have no idea how to do this. Thanks!

[Access_Blaster]

Is your form based on a query?

[darklite]

I'm really not sure. I didn't build the form, somebody else did. I'm just trying to make some improvements. How would I determine if it's built on a query?

[Access_Blaster]

darklite,

Open your database; on the menu under View select design view. Once your form is in design view look to the upper left hand corner for a small black square. Double click the square; the property sheet will open under the tab DATA look at the record source. Try and determine what the source might be. Here are some samples of what you might see:

1. tblWarehouse
2. SELECT tblWarehouse.WarehouseID, tblWarehouse.Dates, tblWarehouse.Signature, tblWarehouse.Driver, tblWarehouse.School FROM tblWarehouse;
3. qryWarehouse

Or some other combination..

Post back when you find out.

Regards,

Richard

[darklite]

I put up an attachment of what I found. I wish i was better with this program, and knew sql and vb, but for now I'm still learning it.

[Access_Blaster]

Its hard to tell from your picture exactly where your record source is coming from. It could be a macro. If you want to upload a copy of your database minus sensitive records we might be able to help you clear this up.

[darklite]

I thank you for the help. I'll play around with it and see what I can come up with.

[Datagopherdan]

Good luck. If you have anymore questions, let us know. I'm sure someone on the boards will be able to assist you.

I thank you for the help. I'll play around with it and see what I can come up with.