Docmd: GoToControl

[renold1958]

Have a form called customers. Names, address etc. Listbox called
SelectCustomer.

And a subform called: CustomerOrders.

In the Subform is a field called Date.

What I want to do is, after selecting customer name in SelectCustomer
listbox on the main form to go straight to the field Date in the subform and
as a new record aswell.

Sofar I have gone to the properties of the list box SelectCustomer and in
the after update property selected Docmd.GoToControl..........what is the
syntax after that?

Docmd.GoToControl ????????????

 

[Rainbow01]

use SetFocus instead of Docmd.GoToControl

"renold1958" 來函：

 

[Van T. Dinh]

SetFocus is the preferred method.

Try:

Me.CustomerOrders.SetFocus
Me.CustomerOrders.Form.[Date].SetFocus

 

[renold1958]

Thanks...learn something new every day

use SetFocus instead of Docmd.GoToControl

"renold1958" 來函：

 

[renold1958]

Thank you kindly, much appreciated

SetFocus is the preferred method.

Try:

Me.CustomerOrders.SetFocus
Me.CustomerOrders.Form.[Date].SetFocus


--
HTH
Van T. Dinh
MVP (Access)

Have a form called customers. Names, address etc. Listbox called
SelectCustomer.

And a subform called: CustomerOrders.

In the Subform is a field called Date.

What I want to do is, after selecting customer name in SelectCustomer
listbox on the main form to go straight to the field Date in the subform
and
as a new record aswell.

Sofar I have gone to the properties of the list box SelectCustomer and in
the after update property selected Docmd.GoToControl..........what is the
syntax after that?

Docmd.GoToControl ????????????