Hi imintrouble,
Try this Code behind your Command Button:
I have textboxes txtStartDate & txtStartTime on my Form.
I have Table fields StartDate & StartTIme.
I'm inserting StartDate & StartTime variables [from the Form TextBoxes] into the Table.
Code:
Dim StartDate, StartTime As Date
Me.txtStartDate.SetFocus
StartDate = Me.txtReportDate
Me.txtStartTime.SetFocus
StartTime = Me.txtReportTime
StrSQL = "INSERT INTO TableName (StartDate, StartTime) "
StrSQL = StrSQL & "VALUES (" & "#" & StartDate & "#" & ", " & "#" & StartTime & "#" & "); "
'MsgBox StrSQL
DoCmd.RunSQL StrSQL
I hope this helps.