Issue on Main form to Subform Cursor Position

[sandya]

Can anyone help on my cursor position problem

On main form cursor working is goods as per default. But after come to in Subform its shown the cursor position in the last filed. So every new record is shown as the same last field. How to do this cursor position will be change in subform as per default?? and every new record its need to show as per default TabIndex "0".

I have checked my Tab Index & Order Settings also it is good. But its shown as last filed in subform

I have attached the Screen shot. Can anyone please check it and give me a replay for how to do changes.

 

[CJ_London]

Have you checked the tab order for the controls on your subform. If you reorder them so model is tab 1 this should solve your problem

 

[sandya]

Actually my Subform fields with index is

Model -------------------"0"
Item Description -------- "1"
Qty ---------------------"2"
Unit Price --------------- "3"
Amount ----------------- "4" ( Amount filed is Enabled: No & Locked: Yes)

So remaining 0 to 3 fields are working with cursor tab. its shown in Unit Price "3" for every new record in subform. so i need to show cursor position in Model - "0" as per default.

Thanks,
Sandhya

 

[CJ_London]

If the tab Index for Model is 0 - have you got the tabstop set to yes?

 

[sandya]

Yes, tab stop set to "Yes" for all fields. Actually this is a small issue not a major. But every new record i can do putting the cursor position in model filed and after i can start the data entry from model field.
So i need to show cursor position as per default without i putting in model field. need to show automatically in "0" index.

Thanks,
Sandhya.

 

[CJ_London]

It sounds like all your settings are correct so it may be the form has become corrupted.

I would compact the db and then build a new form from scratch.

I'm afraid I cannot think of anything else to suggest.

 

[missinglinq]

When you move from Record-to-Record, in Access, by default the cursor remains in the same Control it was in when you moved. To change this behavior, and have a specific Control have Focus when moving to another/new Record, you need to do something like this:

Private Sub Form_Current()
 ControlToGetFocus.SetFocus
End Sub

replacing ControlToGetFocus with the actual name of your Control.

Linq ;0)>

 

[sandya]

Yes its working perfectly. i have tried below code

Private Sub Form_Current()
ControlToGetFocus.SetFocus
End Sub


Thank you so much
Sandhya.