Prevent subform being set focus

[paramesium]

Hi all,

As title, how do I Prevent subform being set focus upon loading?



Also, what should I do so that when I pressed the subform , it will not show the blinking "text tool"?



I know it is a bit troublesome, but it seems confusing for the user since the subform is mean for read-only.

thank you very much!

Regards,
Jack

[ItsMe]

You can adjust the Tab Stop property for the sub form control. Have it = No.

You can also adjust the order of all controls on the Main form using Tab Index.

If you want your subform to behave a certain way, you can edit the subform itself. Open the form in edit view and adjust the properties so the form does not allow edits, additions, or deletions. You can also adjust the Cycle property to Current Record. This will prevent the user from tabbing over to a new record within the form or moving to the next record by hitting Enter.

[paramesium]

You can adjust the Tab Stop property for the sub form control. Have it = No.

You can also adjust the order of all controls on the Main form using Tab Index.

If you want your subform to behave a certain way, you can edit the subform itself. Open the form in edit view and adjust the properties so the form does not allow edits, additions, or deletions. You can also adjust the Cycle property to Current Record. This will prevent the user from tabbing over to a new record within the form or moving to the next record by hitting Enter.

hmm, it works on form, but it doesn't work on a subform....

wonder where I did wrong.

[ItsMe]

Hard to say. I don't know what you did.

On your main form, there is a control that acts as a container for your subform. You can adjust the properties for that control.

This subform container has a source object property. It seems this property is set to look at a form. You can open this form object directly, by selecting the object in your Navigation Pane and opening it in edit view. You can also edit the form object by clicking inside the subform control/container.

By editing the Tab Stop and Tab Index properties the user experience will be affected. You can also edit the form object properties to prevent editing, adding records, deleting records, etc.

[paramesium]

Nice, i was missing out a step just now, it is working now, thanks a lot!

[ItsMe]

There are many nuances to properties. Comb back through the posts I made and play around with the behavior. Post back if you have questions.

[paramesium]

actually I have one more question.

how do you stop scrolling when you see the last record in subform, so that I dont see any blank rows in the subform.

hope you get what I mean.

really appreciate your help, thanks in advance!

[ItsMe]

Maybe
Cycle Records = Current Record
and
Allow Additions = No

for the properties of the form object that is the subform.

[paramesium]

actually what I meant is, I want the scroll bar to stop here:


not able to scroll like the below one.


thank you!

Jack

[ItsMe]

Try resizing your form object. Honestly, not sure what is going on there. I don't believe my form's behave that way. Let me know if resizing helps. If not, I will look at some of my forms and see what I can see.