First off, I made the CustomerSortedQ sorted by last name then first name (both ascending) and used this as the record source for the CustomerListF. However, when I open CustomerListF only the first name field is sorted and I have not been able to spot why this is. Any tips on what I may be overlooking?
Secondly, I was curious about tab order in the customer list. Is it possible to set the tab order to cycle from record to record as opposed to cycling through each field? I tried removing fields from the tab order but was unable to do so. If this is covered later, I'll happily wait until I get there.
Sabin SandersOP
@Reply 20 months ago
Sabin SandersOP
@Reply 20 months ago
Kevin Robertson
@Reply 20 months ago
Look at the Order By property of the Form. It may be overriding the Query sort order.
Richard covered moving through records in this video:
Thank you very much, Kevin. The OrderBy was overriding the query sort. Appreciate the video link as well.
Kevin Robertson
@Reply 20 months ago
You're welcome.
Sabin SandersOP
@Reply 20 months ago
Quick update... I just finished Beginner 8 and was able to achieve the desired tab order simply by making only one field per record a tab stop. Inelegant, perhaps, but effective.
Once again, I appreciate the assistance.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 7.
