Required field

[aharding]

Hello..

I know this has been asked before but i was hoping someone could help me with the codes to have one text or combo box be mandatory to get access to other fields in the form...all others maybe grayed out... until that one box is filled in.

Any suggestions?

[comteck]

Try this. First, set the "Enabled" property to "No" for all textboxes, comboboxes, etc that you want greyed out. Then for the OnExit property for the textbox that you want the others to be dependant on, create an Event Procedure with the following code:

If Me.textbox1 <>"" Then
Me.textbox2.enabled="Yes"
Me.textbox3.enabled="Yes"
Me.combobox2.enabled="Yes"

'and so on

End If

Hope this helps.
comteck

[NeoPa]

In the AfterUpdate subroutine for the controlling TextBox put in code which says

If {condition met} Then
    Object1.Enabled = True
    Object2.Enabled = True
Else
    Object1.Enabled = False
    Object2.Enabled = False
End If

Otherwise, what I normally do (a bit more cryptic)

Object1.Enabled = {condition}
Object2.Enabled = {condition}

[aharding]

In the AfterUpdate subroutine for the controlling TextBox put in code which says

If {condition met} Then
    Object1.Enabled = True
    Object2.Enabled = True
Else
    Object1.Enabled = False
    Object2.Enabled = False
End If

Otherwise, what I normally do (a bit more cryptic)

Object1.Enabled = {condition}
Object2.Enabled = {condition}

Condition being

If Me.POC <> "" Then (from post above???)

The text box does not let me enter any data and all boxes are enable still...i think i need help with the condition....

[NeoPa]

Is this what you're after?

Object1.Enabled = (Me.POC > "")
Object2.Enabled = (Me.POC > "")

[aharding]

Is this what you're after?

Object1.Enabled = (Me.POC > "")
Object2.Enabled = (Me.POC > "")

Thanks...I think its working now!

[comteck]

Sorry about that. I made a mistake. Do what NeoPa said.

comteck