datasheet in subform focus shifting columns

[BJZeak]

This one has me stumped.

I have a form that is eons old which uses a subform with a select * from table; in datasheet mode

the column order does not follow the order of the fields in the table definition plus there are more fields then what can fit on the screen so the horizontal scroll bar is available

When I tab into this subform the columns are static to the first column defined (they stay put as I scroll up and down with the arrow keys) if I scroll horizontally the next vertical scroll takes the column back to the leftmost column

Yesterday I made a new form that allows me to search this table so used this old form as a guide. This new form has a select * from table where <concate of fields> like "*" & getval() & "*"

The problem I am now having is when I tab into the subform on this new form the datasheet does a horizotal scroll to what appears to be the center of the datasheet. OR perhaps it has something to do with the older form as it is using the same column as its first column

I have attemted to hide the fields I am not interested in but for some reason the arrow scrolling stops working with this option

I attempted to shrink the fields sizes but this doesn't appear to work either

Anyone know what is causing this? I have even trapped the Tab at the form level and just issued a setfocus but this doesn't work either

 

[BJZeak]

Arrg ... ok problem solved ... I had used the form wizzard to generate a form using all the fields ... I then selected all the fields and applied a multfield change to say NO to TAB STOP ... somehow one of the fields was either missed or didn't get set to NO.

When this field is hidden the Subform won't scroll

When this field is not hidden because it is a tab stop the subform adjusts itself so that this field is visible.

 

[BJZeak]

Final Note:

I had removed the final tab stop and left this for a day only to return and find it wouldn't scroll anymore

After retracing my steps I found that in order for a Subform datasheet to scroll with the arrow and or page keys there must be at least one visible field/Column set as a tab stop