12-03-2010, 02:31 PM #10 lmcc007 Newly Registered User Join Date: Nov 2007 Posts: 635 Thanks: 0 Thanked 0 Times in

Thanks! Site Message (Message will auto close in 2 seconds)Welcome to UtterAccess! Reason: layout correction Reply With Quote 01-29-2016,12:22 PM #2 Micron View Profile View Forum Posts VIP Windows 7 32bit Access 2007 Join Date Jun 2014 Location Ontario, Canada Posts 1,282 What

Please Wait...

I removed some of the spaces that were in the middle of the FindFirst line of code, and it Ran like it should. I get the following error: RunTime error 3070 The Microsoft Access database engine does not recognize '[myfieldname]' as a valid field name or expression. Want to upload a latest copy? kjv1611 (TechnicalUser) (OP) 27 Aug 04 16:00 Um, oops..

Because it is a subform which company name is on, the companyID links the two together. Register Privacy Policy Terms and Rules Help Popular Sections Tech Support Forums Articles Archives Connect With Us Twitter Log-in Register Contact Us Forum software by XenForo™ ©2010-2016 XenForo Ltd. Log in or Sign up Microsoft Office Forums Forums > Archive > Newsgroup Archive > Access Newsgroups > Access Forms Coding > Run-Time Error 3070 when using FindFirst Discussion in 'Access Get More Info Thread Tools Rate Thread Display Modes 12-02-2010, 04:43 PM #1 lmcc007 Newly Registered User Join Date: Nov 2007 Posts: 635 Thanks: 0 Thanked 0 Times in 0 Posts Error

In those cases, I always test if it exists first If currentproject.allforms("frmName").IsLoaded then... - "doesn't work" doesn't help. Both forms use the same record set. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. If "RouterID" is the name of the field, then why are you looking for "[RouterID_tblRouterArea]"?

Guest, Jul 12, 2006, in forum: Microsoft Access Form Coding Replies: 2 Views: 1,075 Guest Jul 12, 2006 Runtime Error 3070 Guest, Oct 4, 2006, in forum: Microsoft Access Form Coding Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free. Copied the form, got the tables ready > > and > > when I run the following code (that works in the 1st form) I get a RunTime > > Error You seem knowledgable enough for me to say you ought to be posting that you tried running this query and that it did or didn't run, rather than me having to

Join Now For immediate help use Live now! You currently have 0 posts. | "Institutions have a vested interest in perpetuating the problems to which they are the solution." - Clay Shirky MarkK View Public Profile Find More