Tab between records through only 1 column

[flect]

Howdy - I'm just trying to tweak the User Interface of my DB

I want to set up a custom Tab order, but not the way the access wizard does it.

Instead of tabbing through the rows of a record I want to tab through records via the [qty] field.

Basically the "Select Country" box is the master filter for the subform below.

Ideally I want to Tab straight from that box to the subform and then Tab through only the QTY column, and ideally end up back in the master form.

Any ideas? I'm hoping that this is something straightforward and it isn't going to become a VBA nightmare

 

[boblarson]

If you go into the form in design view and then click on each of the controls bound to the fields, you should be able to change their TAB STOP property to NO, all except the QTY one.

 

[flect]

Awesome! perfect! That's exactly what I was after - Cheers.

Any Idea on how to get it to go from the last record in the Subform back to the Country Select in the Parent form?

 

[boblarson]

Awesome! perfect! That's exactly what I was after - Cheers.

Any Idea on how to get it to go from the last record in the Subform back to the Country Select in the Parent form?

It depends, when should it do that?

 

[flect]

Ideally when it reaches the final record displayed, i would like to be able to Tab back to the top,

ie. a tab loop
[countryselect] (main form) -TAB to Qty
[item1QTY] (sub form) - TAB to next
[item2QTY] (sub form)
[item3QTY] (sub form) - TAB back to [countryselect]

It's basically to save the user from having to use the mouse to click back up to the country selection filter.

Not a critical function, but it would be nice to have.

 

[boblarson]

Not sure how to make it do that with a single field and multiple records.

 

[flect]

No problemo

Cheers Bob for all your help! I'd give you more rep but apparently i've given all that I can for moment :-D

Your prompt responses are very much appreciated.

Thank you very much!