Combo Box NULL, Another Combo Box NOT NULL

[mizenerman]

I have a form with two combo boxes. What I'm attempting to do is this:

If Combox A has a certain value I want to make Combox Box B required for entry. The problem is that I'm fairly new to VB and not sure how to make this happen. Any help is much appreciated.

Thanks!

 

[PHV]

In the comboA AfterUpdate event procedure:
If Me![combo A] = "certain value" Then
Me![combo B].Requery
End If

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[straybullet]

Private Sub Form_Unload(Cancel As Integer)
If Me.[combo A] = "certain value" and IsNull(Me.[combo b]) Then
Cancel = True
MsgBox "Combo B cannot be left empty!
Me.[combo b].SetFocus
End If

Let them hate - so long as they fear... Lucius Accius

 

[TheAceMan1]

How are ya mizenerman . . .

[blue]If Combox A has a certain value I want to [purple]make Combox Box B required for entry.[/blue]

Same as [blue]straybullet[/blue] only I'd use the forms [blue]Before Update[/blue] event!

See Ya! . . . . . .

Be sure to see FAQ219-2884:

 

[PHV]

Seems I made a mistake, sorry.
Please disregard my post.

 

[mizenerman]

Thanks Aceman and Stray Bullet. That's exactly what I was needing.

PHV, no worries. You've come thru for me in the past. Your input is much appreciated.

Thanks again everyone!