Combo Box Vailidation - URGENT HELP NEEDED

[T8JGT]

Hi

This is rather complicated to explain, but here goes:

I have a form with 3 combo boxes on it:

- ITSQFDocumentName
- cboServRec
- QualityGate

What i want is in a simple sence

If ITSQFDocumentName = ORQ only allow selection from QualityGate else allow selection from cboServRec.

Can anybody please help.

 

[dRahme]

Hello, in the after update event of your combo box -

Private Sub ITSQFDocumentName_AfterUpdate()

Select Case Me.ITSQFDocumentName

Case Is = "ORQ"
Me.QualityGate.Enabled = True
Me.cboServRec.Enabled = False

Case Else:
Me.cboServRec.Enabled = True

End Select

End Sub

Hope that helps

 

[PHV]

Private Sub ITSQFDocumentName_AfterUpdate()
Me!QualityGate.Enabled = (Me!ITSQFDocumentName = "ORQ")
Me!cboServRec.Enabled = (Me!ITSQFDocumentName <> "ORQ")
End Sub

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[T8JGT]

Thanks