Access

[gheyman]

I have a Field on my form that's a combo box. It defaults to "*". When the user makes selections or leaves it at "*" the value is used as the criteria in a query.

My problem is that sometime the User will delete the value in the Combo box and then run the query. this ends up showing no records - which makes sense. No value in Combo box = no records

But I want to avoid that. I want to either show records based on the selection in the combo or show all.

Is there VBA code so that when the user leaves the combo box after they deleted the value, the code puts back the "*"? An if Null kind of code.

 

[gheyman]

Private Sub Combo84_BidStatus_Exit(Cancel As Integer)
If IsNull(Me.Combo84_BidStatus) Then
[Combo84_BidStatus] = "*"
End If
End Sub

 

[Micron]

That is your solution, or that is what you tried but isn't working??