If the procedure in the form's module is declared Public, you can execute the procedure as a method of the form whenever that form is open. Let's say you have an AfterUpdate event procedure on the frmCustomers form. You changed a value on that form from another form - and you want to run the AfterUpdate code. You can call the procedure like this:
Forms!frmCustomers.Form_AfterUpdate or Form_frmCustomers.AfterUpdate John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ > -----Original Message----- > From: phandhoe [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 17, 2005 3:32 AM > To: [email protected] > Subject: [ms_access] How to call procedure in another form > > > > > i guys, can anyone show me how to call procedure/sub within another > form which opened by clicking a button in the first form? > > thanks > > > > > > > Yahoo! Groups Links > > > > > > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
