Timed Pop up reminder

[Kananelo]

Folks,
Can anybody out there help me with a timed pop up reminder for my database.
I have a form based on a table with the following fields

Date field - Date picker
Time field - Combo box (24hrs, 48hrs, 72hrs & 96hrs)
Task Number - Textbox (Interger)


Completed - Yes/No checkbox

I want my pop up form to remind me of follow ups that are to be done in 48 hours, and others will be in 72 or 96 hours respectively. So i will be reminded of tasks that are to be done in differend time intervals.

I had this pop up previously but now i want to update it to the above. The code is below.

Private Sub Form_Load()
'On Load of the switchboard check RefTbl for any incomplete Jobs
Dim intStore As Integer
'Count of incomplete jobs that are past the Expected Completion Date
intStore = DCount("[Job Number]", "[Reminders]", "[Expected Completion Date] <=Now() AND [Completed] =0")

'If count of incomplete Jobs is zero display switchboard
'Else display message box detailing amount of jobs
'and give the user the option as to whether to view these or not.
    If intStore = 0 Then
            Exit Sub
                Else
                    If MsgBox("There are " & intStore & " incomplete Jobs" & _
                    vbCrLf & vbCrLf & "Would you like to see these now?", _
                    vbYesNo, "You Have incomple Jobs...") = vbYes Then
                    DoCmd.Close , "[Switchboard],,"
                    DoCmd.OpenForm "Reminderfrm", acNormal
                          
                Else
            Exit Sub
        End If
    End If
End Sub

[SteveF]

OK, so it looks like you want a message box to display on program startup to show any incomplete jobs, with a varying timer interval allowed for completion.

I'd design your table differently: instead of having a "time field", I'd make it a "completion date" field, date/time type. Use the combo box to choose the hours interval, but put a date in the table of 1, 2, 3 or four days from today based on the choice.

Then your popup only has to look for items where the completion date is less than (or less than or equal to, your choice) today's date.

Steve