Referencing a control that is a combo box

[Dr. Brad]

Good morning,

I'm using Windows XP Pro and Access XP Pro (2003).

I have a form called Form1; on this form I have a control called
Description. The control is a Combo Box. I want to check Descriptions to
see if it is Null when the control loses focus.

In the Lost Focus event I code:
If Forms! Form1!Description is Null then etc.

Apparently I do not reference the control Description properly? Any
suggestions??

Brad

 

[Lynn Trapp]

If Forms! Form1!Description is Null then

Try changing the code above to:

If IsNull(Me.Description) then
'Your code Here
End If

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Dr. Brad]

Thank you Lynn. It works.

Brad

Try changing the code above to:

If IsNull(Me.Description) then
'Your code Here
End If

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html