if then else problem
Try using "" instead of " ".
--
Dan
On Dec 20, 12:44 pm, "Pierre" wrote:
Hi,
can anybody tell me what is wrong in this snippet of code ?
If search_acc.Value < " " Then
result = search_acc.Value
Column = 23
ElseIf search_status < " " Then
result = search_status.Value
Column = 176
Else: GoTo nochoice
End If
....
various code
....
nochoice:
msgbox "you did not make a choice, make a choice !"
Where search_acc and search_status are comboboxes
Whatever you do, you allways end up with the messagebox from nochoice:
Please help !
Thanks,
Pierre
|