Re: Reference a subform

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Allen Browne (AllenBrowne_at_SeeSig.Invalid)
Date: 02/03/05 

Date: Thu, 3 Feb 2005 14:31:49 +0800

Where did your variable strNameofForm come from?
Could you pass a reference to the form itself, instead of the name of your
form?

Example, create your function like this:
    Public Function RunMyZoomBox(frm As Form)
and then call it like this:
    Call RunMyZoomBox(Me) 

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Leonard" <Leonard@discussions.microsoft.com> wrote in message
news:DC1FEBEF-DDE2-4242-B4AE-215213EF8988@microsoft.com...
> Hi Allen
>
> Thanks for the message. I've used the shift+f2 tool and it works well, but 
> I
> wanted to customise my own zoom form.
>
> Any thoughts on the subform referencing?
>
> Leonard
>
>
> "Allen Browne" wrote:
>
>> You can pop up the built-in zoombox by pressing Shift+F2.
>>
>> Alternatively, you could put a command button beside your text box, and 
>> put
>> this into its Click event procedure:
>>     Me.[NameOfYourTextboxHere].SetFocus
>>     RunCommand acCmdZoomBox
>>
>>
>> "Leonard" <Leonard@discussions.microsoft.com> wrote in message
>> news:A27715F1-9F21-4453-98F4-3B5D36B5BEA5@microsoft.com...
>> > Hi
>> > I've made a generic form to allow text in a textbox on any form to be
>> > 'zoomed' to a bigger textbox on a popup form. When the zoom form closes 
>> > it
>> > updates the textbox control on the original form using:
>> >
>> >   Set frmNameofForm = Forms(strNameofForm)
>> >   frmNameofForm.[txbLetter] = Me.txbLetterZoom
>> >
>> > However, how do I do this when the control is on a subform?
>> >
>> > And, is this called explicit or implicit referencing, or something 
>> > else -
>> > just so I can refer to it in the future.
>> >
>> > Many thanks
>> > Leonard

Relevant Pages

  • Re: Reference If Statement Result
    ... Referencing the textbox itself is not a big problem; ... contain your unbound textbox. ... > is no longer unbound seeing it has an IIF statement in it)? ...
    (comp.databases.ms-access)
  • RE: What is the meaning & use of "& ME!"?
    ... The "Me" keyword is a self-identifier for referencing a property or value ... This will place the name Bob inside the textbox that is on your form. ... form or the txtUserName field to something else, ...
    (microsoft.public.access.formscoding)
  • Re: reference problem
    ... referencing) that the tab control does not exist and the textbox is directly ... "alekm" wrote in message ... > I've got form X and TabControl T on it. ...
    (microsoft.public.access.gettingstarted)
  • Re: System.NotSupportedException
    ... Is it simply the addition of the Textbox without referencing anything else ... full framework that's not supported in the CF. ... > now and suddenly run into a problem that when I add a Control to a Form, ...
    (microsoft.public.dotnet.languages.csharp)