Hi
I have a form that lets me pick 5 numbers for a lottery drawing. The form is unbound. The five numbers are located in ball1, ball2, ball3, ball4 and ball5. These are the names of the text boxes on my form.
I'd like to , in real time, check those 5 text box values against a table, which has all of the past winning numbers.
The winning numbers are stored in a table called tblWinningNums. The field names for each of the numbers are One,Two,Three,Four and Five.
I'd like to know if the combination of numbers I have in the text boxes on the form match any winning number combinations in the table.
My answer may lie in a query but I though there might be some VBA that made better sense.
Thanks
Lefty