Form Edits (Sorting, Tab Order, modified search)

[pokerace]

Greetings,

I would like to make the following edits to a form in Access 2000.

1. Currently I have the form sorting by one date field, so that the Order By command reads [Client Info].[Orig Placement Date]. I would like to change the sort order so that it sorts based on two fields, Last Name and then First Name. Can I sort by two fields and if so how?

2. I have a couple of sub forms with a tab sort order that makes user entry smoother. However, when the user completes the last field hits the tab key, it goes to a new record in the form. Can I end the tab order so that the user can't tab to a new record. It confuses them because they think the data was lost.

3. I currently have a search button that brings up the default find box. If I want the search feature to automatically search the last name field (as default) and always search by any part of the field, how should I do that?

Thanks for any help!

 

[georgedwilkinson]

1. Yes, open the query and select the sort order for the other field you want to sort on. Then open SQL mode and make sure the "order by" clause is in the correct order. Close the query and save it. Try it out.

2. There are tabbing options for forms. Check out the "Cycle" property for the form in question.

3. I'm particularly fond of Access' built in filtering functionality because I'm lazy. To filter on a field, right click on that field and type in your criteria in the "Filter For:" input box on the context menu. You can do some pretty complex filtering this way. However, sometimes that isn't enough. If it doesn't work for you, post back with more details (i.e. field names, which form/subform, etc.).