Heenan, Lambert
Lambert.Heenan at AIG.com
Wed Mar 5 11:16:01 CST 2003
You cannot call a private sub, in a form or a report or a module form anywhere except the form, report or module that defines the sub. That's the whole point of 'Private'. So make your form's sub explicitly public and you will be able to call it with this syntax... forms("YourFormName").YourSubName forms!YourFormName.YourSubName Lambert > -----Original Message----- > From: Rocky Smolin - Beach Access Software [SMTP:bchacc at san.rr.com] > Sent: Wednesday, March 05, 2003 12:04 PM > To: AccessD at databaseadvisors.com > Subject: [AccessD] Syntax to Call a procedure from another form > > Dear List: > > I always have trouble with this syntax: I want to execute or call a > Private Sub in one form (which is open) from a pop up form. Can' remember > the syntax. Anybody know offhand? > > MTIA > > Rocky Smolin > Beach Access Software >