Comparing two data fields in Access through Visual Basic
I have a database that resides in Access. I can access it from
Visual Basic and add new records. But the problem is that i can
not control the entry of data to be saved in these fields.
this is the code that doesn't work
Private Sub qty_orderedText_Validate(Index As Integer, Cancel As
Boolean)
If qty_orderedText.Text < qty_receivedText.Text Then
MsgBox ("Error")
End If
End Sub
I'm writing the above code under both, the text of the fild
qty_ordered and the text box of the field qty_received.
I just want to say that u can not recieve items number more than
the items number u ordered.
Both of the two fields in access are of the same type (Number).
Any help would be appreciated
Thank you
* Sent from RemarQ http://www.*-*-*.com/ The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free!
