Updating Forms by Filter
I have a similar question.
In the "Filter part" of the form, combo boxes populate the data for YearFilter and Cat(egory)Filte r. The default values are preload and the filter works "On Load", but I can't get the data to refresh in the sub-form.. I also tried requery
The "AfterUpdat e" of the ComboBox, I have
Private Sub cboYearFilter_A fterUpdate()...
User Profile
Collapse
-
Can't update a RecordSet
I have basically the same problem... (and I'm a Newbie). I have a sub-form that is being filtered based on the combo boxes available. The underlying query is straight forward for most selections... meaning the fileds are contained in a single table; no issues there. In one combination, the key field, status, is in a "related" table and a join is required. When that happens, the Project data is not editable.
MyCode when "only...Last edited by Stewart Ross; Apr 30 '09, 03:55 PM. Reason: Added code tags to code and split code lines for readability - please use the code tags provided.
No activity results to display
Show More
Leave a comment: