Bill Benson
bensonforums at gmail.com
Tue Apr 29 10:13:22 CDT 2014
This is more like it! Thanks Jim, I agree with you. Art, you can cancel my request unless you disagree with Jim! 'Twould be a purdy stupid property that dissipates just before you need it. Kinda the opposite of Experience, which doesn't show up until after you need it. For the record, I believe in global variables and SaveSettings/GetSettings - even, on occasion, in temp tables - because you can reach and/or modify these at will from all over an application (even after a Compact & Repair in the latter's case...) without relying on something sent into an opening form's arguments. I guess I might use OpenArgs if I knew for sure I would never open a form recursively or open one form that might consume/destroy the data I could possibly need for another form. On the other hand, the same logic that tells me what to set for OpenArgs could be telling me what to be storing as which controllers, for which Forms, in an OPENING_DIRECTIVES table which I intend to look up to from within the opening form. That way I get different data types to play with, not some densely populated string which OpenArgs is. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman Sent: Tuesday, April 29, 2014 10:59 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Openargs Mystery Their good for the life of the form as long as you don't break code execution. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller Sent: Tuesday, April 29, 2014 10:39 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Openargs Mystery Rocky, This is known behaviour. If you really want to keep the OpenArgs then grab them immediately and store them; otherwise they are toast as soon as anything happens. On Tue, Apr 29, 2014 at 10:32 AM, Gustav Brock <gustav at cactus.dk> wrote: > Hi Rocky > > Have you tried removing the call of adhScaleForm? > > /gustav > > -----Oprindelig meddelelse----- > Fra: accessd-bounces at databaseadvisors.com [mailto: > accessd-bounces at databaseadvisors.com] På vegne af Rocky Smolin > Sendt: 29. april 2014 15:52 > Til: 'Access Developers discussion and problem solving' > Emne: [AccessD] Openargs Mystery > > Dear List: > > I call a form which is bound to a table with a list of companies. The > called form is where the data for the company is entered/edited. So I pass > the autonumberID, the PK of the company to the called form, do a FindFirst, > and walla! company is displayed. I use this technique a lot. > > So the calling statement is: > > DoCmd.OpenForm "frmAssociations", , , , , , > Me.fldSRAssociationID > > I put a breakpoint here and hover over Me.fldSRAssociationID and sure > enough the value 10005 is in Me.fldSRAssociationID. > > Press F8 and the _Open event of the called form executes: > > Private Sub Form_Open(Cancel As Integer) > > Call adhScaleForm(Me, 1600, 800, 96, 96, rctOriginal) > > If Not IsNull(Me.OpenArgs) Then > Me.RecordsetClone.FindFirst "fldAssociationID = " & > Val(Me.OpenArgs) > Me.Bookmark = Me.RecordsetClone.Bookmark > End If > > End Sub > > At the point where the first line of code is ready to execute (I'm in > break mode now so the execution stops on every line) I hover over > Me.OpenArgs and it shows Me.OpenArgs = Null. > > Where's my OpenArg? Why does it disappear. I never saw this behavior > before. Any ideas? > > This is A2003 BTW. > > MTIA > > Rocky > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- Arthur -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com