Validation-Combo Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I have a problem validating the data in combo box
Default value of Combo Box = " "
3 items in drop down

I need to restrict the user to go forward to the next tab , unless he enters
on of the three dropdown items.

Thanks in advance
 
Hi, Ron.

Ensure that the field that the combo box is bound to is both required and
cannot allow zero length strings. Then use the combo box's OnNotInList( )
event to ensure that one of the three values is selected:

Private Sub cboStuff_NotInList(NewData As String, Response As Integer)

On Error GoTo ErrHandler

MsgBox "Please enter one of the items in" & vbCrLf & _
"the combo box.", vbCritical + vbOKOnly, "Must Select One Item!"
Response = acDataErrContinue

Exit Sub

ErrHandler:

MsgBox "Error in cboStuff_NotInList( ) in" & vbCrLf & _
Me.Name & " form." & vbCrLf & vbCrLf & _
"Error #" & Err.Number & vbCrLf & Err.Description
Err.Clear

End Sub

.. . . where cboStuff is the name of the combo box.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
 
The validation can be

If trim(Me.Combo1)="" Or isnull(Me.Combo1) then
msgbox "Must enter value in combo1"
me.Combo1Name.SetFocus
End If

The same validtion can for the other combo's

The valdation can be on the On change event of the TAB control you are
using, if you are using
 
try *not* setting a default value in the combobox control. then you can
check the value of the combo box before allowing the user to move to another
page in the tab control.

each Page in a tab control has a PageIndex property. the tab control's value
is equal to the PageIndex property of the currently selected Page. for
example, say the current Page of a tab control has a PageIndex setting of 3.
if you don't want to move from that Page to another Page until a value is
entered in a combo box, you can use the following code in the tab control's
OnChange event procedure, as

If IsNull(Me!MyComboBox) Then
Me!MyTabControl = 3
End If

hth
 
Back
Top