Many thanks in advance! HTH, TC "a s i l b a . Note: frmTest is a simple form with code behind form so it can be instantiated through the form's class module. Aug 12 '10 #10 reply Message Cancel Changes Post your reply Join Now >> Sign in to post your reply or Sign up for a free account. check over here
bye: Set frm = Nothing Exit Sub errHandler: Select Case Err Case 2450 'can't find form MsgBox "What is hapening here!???..." & vbCrLf & "Can't find this form???" Case Else MsgBox Forms![frm_Test]![frm_SubTest].Form.Bookmark = rst.Bookmark End If rst.Close Set rst = Nothing 'DoCmd.Close End If End Sub But now, I get the same error but instead of saying it can't find the FORM But can you give a more concrete example of how to pass the client id into it? Anyway, I just turned around this issue, by using a numeric reference to the form instance, as sugested.
Dec 22 '08 #2 reply Expert 100+ P: 489 DonRayner You need to refer to the subform by refering to it's main form first Expand|Select|Wrap|Line Numbers Forms!MainForm.Form!OperatingSupplies.RecordSource=strRecordSource Dec 22 '08 Hello again, Thanks for everything. Is it possible to hand start modern planes? The Following 2 Users Say Thank You to RuralGuy For This Useful Post: fluid(11-02-2012), mjcaestecker(08-17-2012) RuralGuy View Public Profile Find More Posts by RuralGuy
But they all have the same name so to reference them individually it seems one needs to use a numeric reference. -- Lyle (for e-mail refer to http://ffdba.com/contacts.htm) Nov 12 '05 Would still like to know why the methods I tried didn't work, but still happy to have a way forward, so thank you again! share|improve this answer answered Sep 19 '13 at 20:13 Andy G 13.4k52449 Thank you. +1 for trying to help. Access Vba Close Form Public Sub sbTest() On Error GoTo errHandler Dim frm As Access.Form 'create new instance of the class Form_frmTest Set frm = New Form_frmTest 'make form visible frm.Visible = True 'get form's
As a monk, can I use Deflect Missiles to protect my ally? Solving a discrete equation TIKZ: foreach not compatible with calc-library? So Access has no problem finding Forms("NameofForm"). Is it possible to check where an alias was defined?
Join them; it only takes a minute: Sign up Access cannot find the referenced form up vote 1 down vote favorite I am in the final stages of testing a small Tom Nov 12 '05 #7 P: n/a a s i l b a . This is the (partial) code I'm using: DoCmd.OpenReport "Invoice", acViewPreview If (Forms![Customer Picker]![Combo3].Value = "Business") Then Reports![Invoice]![Text154] = Forms![Customer Picker]![Text8] Else Reports![Invoice]![Text154] = Forms![Customer Picker]![Text10] + " " + Forms![Customer Picker]![Text6] Public Sub sbTest() On Error GoTo errHandler Dim frm As Access.Form 'create new instance of the class Form_frmTest Set frm = New Form_frmTest 'make form visible frm.Visible = True 'get form's
What do you call the practice of using (overly) complex words specific to a subject? If you do then you'll need to reference the subform through the main form. Runtime Error 2450 Cannot Find The Referenced Form Hello, I have a similar problem trying to access (no pun intended) subform fields in VBA. Runtime Error 2450 Access Can't Find Form when frmtest is open Arno R "Tom Wickerath"
Access can't find subform P: 4 chickenhawk I'm using a search engine in VBA to return a new RecordSource to a SubForm, but when I attempt to apply the new SQL http://rinfix.com/cannot-find/usr-bin-ld-cannot-find-lgl.html RuralGuy View Public Profile Find More Posts by RuralGuy 11-02-2012, 07:22 AM #5 fluid Newly Registered User Join Date: Nov 2008 Posts: 44 Thanks: 11 Close Box Join Tek-Tips Today! p t"
Note: frmTest is a simple form with code behind form so it can be instantiated through the form's class module. How do I deal with my current employer not respecting my decision to leave? Excel Video Tutorials / Excel Dashboards Reports Reply With Quote June 16th, 2006 #6 A9192Shark View Profile View Forum Posts Established Member Join Date 14th September 2004 Location Surrey, England Posts http://rinfix.com/cannot-find/usr-bin-ld-cannot-find-lc.html Dec 22 '08 #6 reply P: 4 chickenhawk I figured out a solution: Expand|Select|Wrap|Line Numbers DimfrmAsForm_OperatingSupplies Setfrm=Form_OperatingSupplies frm.RecordSource=strRecordSource frm.Requery Seems to be working perfectly.
Web|-- Other Microsoft ProductsPC|-- Network Issues|-- Q & A - Hardware|-- Q & A - Software|-- Q & A - Other PC|-- Virus + Security DiscussionUtterAccess Odds and Ends|-- General Chat|-- Why?... Hope This Helps, PH.
Thanks in advance, Nik. Are you saying I'd have to do something like: VB: Forms([I]main form[/I]).subform([I]subform[/I]).[I]etc[/I] (I know that's wrong) How exactly do I reference the subform through the mainform? That is Cool! For some reason, I cannot pass the value from the text box to VBA or another text box on the main form because Access "cannot find the form" Here's the code
Last edited by ski52; January 24th, 2006 at 03:34. Is calling a function with local side-effects twice in the same expression undefined behavior? It is layed-out in an Outlook style with some icons running down the left side, continous form data in the middle form, and then a search engine form at the top. have a peek at these guys Tom ____________________________________________ "a s i l b a .
If you get an error message then you are not inside the form module. mjcaestecker View Public Profile Find More Posts by mjcaestecker 08-17-2012, 02:16 PM #4 RuralGuy AWF VIP Join Date: Jul 2005 Location: @ 8300' in