Code:
Private Sub edit_record_Click()
Dim formName As String
Dim dateSearch
dateSearch = Me.date_to_search.Value
TempVars("search_date").Value = dateSearch
formName = "edit_actuals"
DoCmd.OpenForm formName, acNormal
End Sub
code on qry:
Code:
SELECT data_Workflow_Log.ID AS Workflow_ID, data_Workflow_Log.ID, data_Workflow_Log.Date_Entered, data_Workflow_Log.Agent_Name, data_Workflow_Log.[Ad-Hoc], data_Workflow_Log.Action_Items, data_Workflow_Log.Dependencies, data_Workflow_Log.Risks_Issues
FROM data_Workflow_Log
WHERE (((data_Workflow_Log.Date_Entered)>=[tempvars]![search_date]) AND ((data_Workflow_Log.Agent_Name)=fOSUserName()))
ORDER BY data_Workflow_Log.Date_Entered;
Again, the query returns correct info, but the form also shows todays record, no matter what. I am assuming it is a form preset so any ideas? It is not set to data entry, and it allows additions, deletions, edits, and filters.