Results 1 to 2 of 2
Thread: "Refresh" data in subform
2001-06-18, 18:17 #1HarmacyGuest
"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!
2001-06-18, 19:23 #2
- Join Date
- Jun 2001
- Crystal Beach, FL, Florida, USA
- Thanked 36 Times in 35 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):