Set Focus / GoTo

[Petros]

Hi all,

why does this not function:

If Me![Fruits] = "Bananas" Then
DoCmd.Save
Forms![Form2].[Comments] SetFocus
End If

Forms2 is a subform

Thanks!

 

[pbaldy]

For starters:

http://www.mvps.org/access/forms/frm0031.htm

If that's a cut/paste, it would be:


...ControlName.SetFocus

no space.

 

[boblarson]

Hi all,

why does this not function:

If Me![Fruits] = "Bananas" Then
DoCmd.Save
Forms![Form2].[Comments] SetFocus
End If

Forms2 is a subform

Thanks!

Well, it could be several reasons.

1. Is the field FRUITS in your form's record source?

2. DoCmd.Save has nothing to do with saving a record.
DoCmd.RunCommand acCmdSaveRecord
is the right one to use.

3. A subform has different syntax than what you have there.

Forms!YourMainForm.SubformControlName.Form.ControlOnSubform

So, SubformControlName is the name of the control on the main form which houses the subform. It is not the name of the subform (unless the subform control and the subform are named exactly the same thing).

And the .Form. part is to be left EXACTLY as shown. It tells Access you want a property or method of the form and not the subform control that is on the main form.

 

[Petros]

For starters:

http://www.mvps.org/access/forms/frm0031.htm

If that's a cut/paste, it would be:


...ControlName.SetFocus

no space.

I appologise for my ignorance Paul...

I am on the main form and i want to setfocus to a specific controll on SUB 1

Me!Form2.Comments.SetFocus

i am doing something very wrong but it just does not function...

 

[pbaldy]

I believe to move focus to a control on the subform you must first set focus to the subform itself.

 

[Petros]

I believe to move focus to a control on the subform you must first set focus to the subform itself.

Yes..that did it...

Why are the most simple solutions most difficult to understand?

Thanks indeed all for your asistance..i learned something new today!

 

[pbaldy]

Happy to help.