After Update Move Focus to Subform

[mattc66 via AccessMonster.com]

I have a Drop Down box on a main form that finds an item. One it find the
item in the after update event I want the cursor to move the a field in my
subform.

I tried the below code:
Me.Form![subForm].Form![FieldName].SetFocus

It didn't work?

 

[Allen Browne]

AfterUpdate is possibly too early to do this.
You could use the LostFocus event of the combo.
Explicitly save the record first (assuming the main form is bound).

You also need to set focus to the subform control first (so it becomes the
active control of the main form).

Result:
Me.Dirty = False
Me.[subForm].SetFocus
Me.[subForm].Form![FieldName].SetFocus

It might be possible to set the Tab Order of the form and the Tab Stop of
the controls so that it automatically goes to the subform control without
any code.

(Presumably subForm and FieldName are just examples, not the actual names.)

 

[eos]

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George

 

[eos]

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George