run time error 94

[CHEECO]

Hello everyone. I found a appointment calendar I am trying to get working. When I open the appointment form I get an :Invalid use of null" error but the form opens anyway after I close the error window. When I click new appointment I get the error again and it high lights the line

vDateTime = CDate(OpenArgs)


I do not understand this error. I have included the code.

Public Sub EnableFields()
'Reset input fields to default values and disable'
Dim vDateTime As Date
    Me.cboStartTime.Enabled = True
    Me.cboEndTime.Enabled = True
    Me.txtStartDate.Enabled = True
    Me.txtEndDate.Enabled = True
    Me.txtSubject.Enabled = True
    Me.txtLocation.Enabled = True
    Me.txtNotes.Enabled = True
    Me.cmdStartDate.Enabled = True
    Me.cmdEndDate.Enabled = True
    
    vDateTime = CDate(OpenArgs)                                         'fetch appointment date from OpenArgs
    Me.txtStartDate = DateValue(vDateTime)                              'show default appt start date
    Me.txtEndDate = DateValue(vDateTime)                                'show default appt end date
    Me.cboStartTime = TimeValue(vDateTime)                              'and default Start Time
    Me.cboEndTime = DateAdd("n", conPeriod, Me.cboStartTime)            'and default End Time
    Me.txtSubject = ""
    Me.txtLocation = ""
    Me.txtNotes = ""
    Me.chkExported = False
End Sub

Thank-you

Cheeco

[CJ_London]

openargs is a variable that is passed as a parameter in the openform command - sounds like you are not providing a value - so your problem is in the code which opens the form or you are trying to open the form directly from the navigation window.

[CJ_London]

modify your code to

vDateTime = CDate(nz(OpenArgs,Date())

and it will probably open on todays date

[orange]

Where is your code to open the form?
Can you show the link to the code you "found"?

[CHEECO]

Thank-you Ajax. I changed the code and it now works. I have another issue that has popped up. I don't think it has anything to do with the change though. I have a google map search in the data base and for some strange reason I am getting a "To Help Protect Your Security, Internet Explorer has blocked this website from displaying content with security certificate errors. Click here for options..." text box thatI have to close each time. I have not used the search is a while so I don't know when it started popping up.

[CJ_London]

suggest start a new thread - this is a completely different issue