Subform Quirkiness - Cursor Jumps
Hi all!
I have an interview program where a respondent gives a free-listing of 'items' with no minimum or no maximum number. Once they have given the list I need to be able to re-rank this list while keeping tabs of the original order with which they were given. Because I don't know how many 'items' the respondent might give I devised a table with five variables: Index (auto-number), RespID, OriginalOrder, Item, FinalRank.
I have a subform within a form that shows the RespID(locked), OriginalOrder, Item, FinalRank. The last three are enabled and the entry person can navigate up-down left-right within the subform.
Ok, so the quirkiness is: once I enter the first record item(i.e., OriginalOrder and Item) and then tab or arrow down to insert/create the second record beginning in the OriginalOrder field the cursor jumps back to the first record OriginalOrder field. However, once I have entered a second record then I do not have that issue within OriginalOrder again. Additionally, once I have all my items and then begin to re-rank the list via the FinalRank field then once again when I get to the second record (which already has info: OriginalOrder and Item) the cursor jumps home from the FinalRank second record field to the first record OriginalOrder field. When I bring it back and enter the rank for the second record and move on, I do not have that issue again within that free-listing form.
My problem is that I have 7 of these forms and the issue happens exactly the same on everyone of them.
Does anyone have any ideas on how I can prevent this from happening?
Thanks ~ Scot
Hi all!
I have an interview program where a respondent gives a free-listing of 'items' with no minimum or no maximum number. Once they have given the list I need to be able to re-rank this list while keeping tabs of the original order with which they were given. Because I don't know how many 'items' the respondent might give I devised a table with five variables: Index (auto-number), RespID, OriginalOrder, Item, FinalRank.
I have a subform within a form that shows the RespID(locked), OriginalOrder, Item, FinalRank. The last three are enabled and the entry person can navigate up-down left-right within the subform.
Ok, so the quirkiness is: once I enter the first record item(i.e., OriginalOrder and Item) and then tab or arrow down to insert/create the second record beginning in the OriginalOrder field the cursor jumps back to the first record OriginalOrder field. However, once I have entered a second record then I do not have that issue within OriginalOrder again. Additionally, once I have all my items and then begin to re-rank the list via the FinalRank field then once again when I get to the second record (which already has info: OriginalOrder and Item) the cursor jumps home from the FinalRank second record field to the first record OriginalOrder field. When I bring it back and enter the rank for the second record and move on, I do not have that issue again within that free-listing form.
My problem is that I have 7 of these forms and the issue happens exactly the same on everyone of them.
Does anyone have any ideas on how I can prevent this from happening?
Thanks ~ Scot
Last edited: