BrenoAguiar
IS-IT--Management
I have a cosstab query "cross1" that brings the result:
placeID | 001 | 002 | 003 |
21 02 03 78
28 12 0 45
02 05 10 20
I have an unbound form with a combo box having the "placeID" options and another Combo box with the "items", beeing the items 001, 002, 003, and so on..
What I want is that if the user selects the combo "items" and the value = 0, then End sub. I tried Something like this:
If DLookup("[Me.items]", "[cross1]", "[placeID] = Me.placeID)= 0 Then
MsgBox "You selected an Item that is Showing 0.", vbOKOnly, "NO item available"
Exit Sub
Can I use the Me.items value as a field in the Dlookup function?
Thanks for any help at all!
placeID | 001 | 002 | 003 |
21 02 03 78
28 12 0 45
02 05 10 20
I have an unbound form with a combo box having the "placeID" options and another Combo box with the "items", beeing the items 001, 002, 003, and so on..
What I want is that if the user selects the combo "items" and the value = 0, then End sub. I tried Something like this:
If DLookup("[Me.items]", "[cross1]", "[placeID] = Me.placeID)= 0 Then
MsgBox "You selected an Item that is Showing 0.", vbOKOnly, "NO item available"
Exit Sub
Can I use the Me.items value as a field in the Dlookup function?
Thanks for any help at all!