Identifying a control name 1

[dhanus]

In the code below, how do I identify the name of the current control in the loop ?

There are a couple of fields in the form that can be left blank. I would like to check if the blank controls are these fields before popping the message.



For Each ctl In frm.Controls

If ctl.ControlType = acTextBox Or ctl.ControlType = acComboBox Then

If IsNull(ctl) Then


MsgBox "Please complete form !", vbInformation
Exit For
Exit Sub

End If

End If

 

[KenReay]

hi

ctl.name

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[dhanus]

Hi Ken

Thank-you for your help.

How can I refer to the ctl.name, i.e. I would like to set focus to that blank control ?

Docmd.GoToControl "how do I reference this?"

Best Regards
Dhanus

 

[dhanus]

It's ok, Ken. I found the answer :

ctl.SetFocus