Results 1 to 2 of 2
  1. #1
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496

    date field in subform not becoming null

    I have one control txtCancellationDate(locked property is true) on a subform that won't null on status change (combo box)

    I have



    Code:
    If StatusID = 5 Then
    Me.txtCancellationDate.Value = Date
    Me.Box408.Visible = True
    Me.CancellationContact.Visible = True
    Me.txtCancellationDate.Visible = True
    Me.CancellationNotification.Visible = True
    Me.CancellationReasonID.Visible = True
    Me.BookingsID_tblBookings.Visible = True
    Me.Label403.Visible = True
    Me.Label404.Visible = True
    Me.Label405.Visible = True
    Me.Label406.Visible = True
    Me.Label407.Visible = True
    Else
    Me.txtCancellationDate.Value = Null
    Me.CancellationContact.Value = Null
    Me.CancellationReasonID.Value = Null
    Me.Box408.Visible = False
    Me.CancellationContact.Visible = False
    Me.txtCancellationDate.Visible = False
    Me.CancellationNotification.Visible = False
    Me.CancellationReasonID.Visible = False
    Me.BookingsID_tblBookings.Visible = False
    Me.Label403.Visible = False
    Me.Label404.Visible = False
    Me.Label405.Visible = False
    Me.Label406.Visible = False
    Me.Label407.Visible = False
    End If
    The string and integer fields null fine - just not the date field (not sure if because it is locked by why should that matter??

  2. #2
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496
    Nevermind - my mistake sorry guys

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Date Range search on Field with null Values
    By vbafun in forum Queries
    Replies: 6
    Last Post: 12-06-2013, 07:26 AM
  2. Null alternative for Date/Time field
    By tylerg11 in forum Forms
    Replies: 1
    Last Post: 04-11-2012, 04:04 PM
  3. Replies: 2
    Last Post: 01-03-2012, 06:54 PM
  4. Passing a NULL value to a date field
    By lman in forum Queries
    Replies: 2
    Last Post: 02-22-2011, 02:20 PM
  5. Replies: 2
    Last Post: 09-27-2010, 02:17 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums