p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access (http://p2p.wrox.com/forumdisplay.php?f=18)
-   -   Refresh Parent Subform (http://p2p.wrox.com/showthread.php?t=34410)

echovue October 18th, 2005 05:55 PM

Refresh Parent Subform
 
Hopefully someone has experienced something like this before.

Form1 contains events has a subform which contains all employees linked to the event. A combobox lets the user pick from all employees and add them to the subform - The subform is refreshed and the name appears.

If the user needs to add a new Employee, he clicks a button which opens the Employee entry form. When closed, the app adds the Employee to the tabel to which the subform is linked. However I cannot get the form to refresh. The employee is on the subform, because if I add an existing employee, both then show up, and if I close the Form and reopen it, the employee appears. I have tried refreshing, requerying, repaint and even closing and opening the Events form programatically - I just can't get the subform to refresh. Anyone have any ideas?

Thanks

Mike

Mike
EchoVue.com

dartcoach October 18th, 2005 09:59 PM

Mike,

Try refreshing the parent form

Forms![ParentForm].refresh
then refresh the subform:

Forms![ParentForm].[Subform].form.refresh

Kevin

dartcoach


All times are GMT -4. The time now is 03:22 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.