User Profile

Collapse

Profile Sidebar

Collapse
RogerThis
RogerThis
Last Activity: Apr 29 '09, 10:11 PM
Joined: Apr 29 '09
Location: Ontario, Canada
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • RogerThis
    replied to Forms AfterUpdate
    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()...
    See more | Go to post

    Leave a comment:


  • RogerThis
    started a topic Can't update a RecordSet

    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...
    See more | Go to post
    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
Working...