Setfocus on a subform 1

Umbane · Nov 30, 2000

I have a form with a subform, and the subform has a subform also. On the main form, in the form header section I have an unbound combo box from which the user must select a client. On the after update event of the combo box I want the focus to go to a record on the second subform so that data can be input directly.
All the references to how this should be done I have followed, but the focus remains on the combo box.
Here is a sample of my code.

[Deliveries].Form![Jobs]![ProductID].SetFocus

Thanks in advance

Umbane

MissyEd · Dec 8, 2000

Hi there
Try:
Forms!Mainform!Subform1.Form!Subform2.Form!ControlName

Check out:

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

Missy Ed
Looking to exchange ideas and tips on VB and MS Access development as well as office 97 development. Drop me a line: msedbbw@hotmail.com

Umbane · Dec 10, 2000

Hi Missy Ed

Thanks for the help but it still does not move the focus to the desired field. Maybe I should try redesigning my form so that it doesn't need all the subforms.

Umbane

jimmythegeek · Dec 14, 2000

I have had trouble with this in the past as well. Try this:

If you want to go to a particular field:

DoCmd.GoToControl "SubFormName"
DoCmd.GoToControl "FieldName"

If you want to go to a new record:

DoCmd.GoToControl "SubFormName"
DoCmd.GoToRecord , , acNewRec

This has worked for me in the past, and the only help I could find on the subject, said to do it this way.
Jim Lunde
compugeeks@hotmail.com
Custom Application Development

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Setfocus on a subform 1

Umbane

IS-IT--Management

MissyEd

IS-IT--Management

Umbane

IS-IT--Management

jimmythegeek

Programmer

Similar threads

Part and Inventory Search

Sponsor