Hello -
I have a report that shows an itemized list of events and sub events. I have an "edit" button next to each date which pulls up a form to edit that event. The form is built off a query that pulls all events greater than or equal to that event (because if the user edits one event, they need to edit all future events as well).
The query the form is based on runs fine. It only pulls that date and all future dates, however, when I am in the form, if I hit the next button enough, it goes to the end and then views the entry with todays date. No idea why, esp. because that record does not show when I look at the query. Any ideas?
code on rpt:
code on qry: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
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.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;
Thanks for any help!