Results 1 to 2 of 2
  1. #1
    Harmacy
    Guest

    "Refresh" data in subform

    I have a subform on my main form that lists employee appraisal dates. I click a button from my main form to open the "promotion" form. When I close the "promotion" form, all the appraisal dates are updated (using delete, append, and union queries). The only problem is that the subform displays "*deleted*" instead of the new dates.

    I've tried using the refresh and requery commands on the form and subform (on open and on activation), but these have not worked.

    Can someone tell me how to get the information in the subform updated with the new dates when I go back to the main form? Thanks!

    Access2000, sr1

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: "Refresh" data in subform

    There are several places to put it, depending on how you call that promotion form. In your promotion form's Close event, you can tell it to requery the subform on the mainform, like this (substitute your own form and control names):

    Forms!yourFirstFormName!subformControlName.requery
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •