I'm not sure if this is better suited for queries or forms, so I'm dumping it here.
- I have a continuous form (frmEmployeeVis) that displays the records in the form's Record Source (SELECT (whatever) FROM dbo_EmployeeData). One of these fields, NotActive, can be edited for each record and affects how that record displays elsewhere in my DB.
- I have a query (qCurrentHC) that counts all of the records in dbo_Employee data where NotActive equals False (SELECT Count(*) FROM dbo_Employee Data WHERE (dbo_EmployeeData.NotActive="False")
- Right now, I have a List Box that displays the result of the qCurrentHC query, where the row source simply selects the only value
It all works fine. The records display, the query runs, and the list box displays the number. However, if I change any of the NotActive values and hit update (Me.Requery on the frmEmployeeVis), the qCurrentHC query obviously doesn't update since it isn't the form's record source. If I open any of my other forms with qCurrentHC displayed in this manner, or reopen this form it will update since it'll rerun the query then.
How do I get the query to rerun when I update this field on that form? I feel like I'm approaching the problem wrong from the beginning, and there is no reason behind how I did it aside from it was the first thing that *almost* worked. Any help is appreciated as always.