MsgBox to display if DateID in subform matches combo

[ScrmingWhisprs]

I have a volunteer tracker DB, and on my Worker's form, there is a subform that shows each night a volunteer has worked. The subform's recordsource is tblTransactions, the fields which include tID, DateID, Worker, TimeIn, and TimeOut.

I have a form that runs in the background that has a combobox that is based on tblDates, fields being: DateID, ShortDate. What happens is the user selects the date for that particular night, which is used for the sign in forms (when a user goes to sign a worker in, the DateID from the combo is put into the DateID field in tblTransactions.

What I need to happen is if that worker is already signed in for that DateID, I need a messagebox to appear to let the user know that worker is already signed in.

Thanks for the help.
SW

 

[rainman89]

you would use a combonation of dcount and dlookup to establish this..

if dcount(blah blah blah) >1 then
MSGBOX "You are already signed in", vbokonly