Using VBA and input boxes to select from table

[shabbaranks]

Hi all,



after a bit of help as to how I get my vba code to pop up input boxes and store whats input to query a table. I dont really know what I am doing so someone to assist would be appreciated. Here's my current code which prompts the user for thier choices

Private Sub TotalHours_btn_Click()
Dim strInput1 As String
Dim strInput2 As String
Dim strMsg1 As String
Dim strMsg2 As String

strMsg1 = "Enter the name of the client you want total hours for"
strMsg2 = "Enter the name of the person you want total hours for - leave blank for all employees"
strInput1 = InputBox(Prompt:=strMsg1, title:="Select Client")
strInput2 = InputBox(Prompt:=strMsg2, title:="Select Employee")
docmd.RunSQL Select from TimesheetTable where

Am I far from the tree??? Thanks

[shabbaranks]

Am I going about this the right way -or should I be using a form to do this?