Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    Nashville, TN
    Posts
    557

    Unanswered: SQL/VBA Query Date Help

    I am trying to use the following code to open a form and select only the date that was selected in lstDate.

    Code:
    Private Sub cmdEdit_Click()
        On Error GoTo cmdEdit_Err
        Expire = lstDate
        DoCmd.OpenForm "CCaulk"
        [Forms]![CCaulk].RecordSource = "SELECT Caulk.Expires FROM Caulk WHERE Caulk.Expires =" & Expire
    
    cmdEdit_Exit:
        Exit Sub
    cmdEdit_Err:
        MsgBox Err.Description
        Resume cmdEdit_Exit
    End Sub
    Thanks,
    JS
    Have you ever thought about thinking on purpose?

    Jarvis Stubblefield
    Patriot Designs
    Web/Database Development and Consulting
    The-Patriot.net by Patriot Designs

  2. #2
    Join Date
    Mar 2004
    Location
    Nashville, TN
    Posts
    557
    I got it all figured out Thanks
    Have you ever thought about thinking on purpose?

    Jarvis Stubblefield
    Patriot Designs
    Web/Database Development and Consulting
    The-Patriot.net by Patriot Designs

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •