Home > Not Working > Not Working Dlookup

Not Working Dlookup

more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed The query would include an INNER JOIN (Type 1 link) between the two tables based on the [customerCode] field. Presentation Software MS PowerPoint MS Applications MultiMedia Applications Web Graphics Software Access Desktop Databases – A Quick Tour Video by: Jim What’s inside an Access Desktop Database. See FAQ181-2886 RE: DLookup Not Working papic1972 (TechnicalUser) (OP) 13 Apr 04 21:31 Hi Roy,I placed this code in the "OnClick" event of a command button on frmJob that is used this contact form

When you get the error message try typing 'Debug.print CustomerCode' in the 'Immediate Window'. (To open and close the Immediate Window press Ctrl-G.) For debugging this problem you can also try Works like a treat now. I think that's not the case. in both the form and in the subform. http://www.access-programmers.co.uk/forums/showthread.php?t=204289

Private Sub cboZipCheck_AfterUpdate() Me.txtCity = DLookup("City", "tblZipCodes", "Zipcode” = me.cboZipCheck) Me.txtCity = DLookup("State", "tblZipCodes", "Zipcode” = me.cboZipCheck) End Sub However it will work if I put it like this Then your code should look like this: Private Sub cboZipCheck_Change() Me.txtCity = DLookup("City", "tblgeoinfo", "Zipcode='" & Me.cboZipCheck & "'") Me.txtState = DLookup("State", "tblgeoinfo", "Zipcode='" & Me.cboZipCheck & "'") End Join UsClose MenuExperts Exchange Browse BackBrowse Topics Open Questions Open Projects Solutions Members Articles Videos Courses Contribute Products BackProducts Gigs Live Courses Vendor Services Groups Careers Store Headlines Website Testing Ask Thanks for the effort in helping.

All rights reserved.Unauthorized reproduction or linking forbidden without expressed written permission. And thanks JANR, I'll start again and make sure to include an ID field. To start viewing messages, select the forum that you want to visit from the selection below. This is on the same computer.One of the Dlookups in question is CODE=DLookUp("[Value]","[tblMC]"," [Code] = '" & [ASX Code] & "' And [YearEnd] = " & [ListYear]) The VBA code for

Quick Repair worked. First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone. more hot questions question feed lang-vb about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation Resources Join | Indeed Jobs | Advertise Copyright © 1998-2016 ENGINEERING.com, Inc.

Your cache administrator is webmaster. to help distinguish between a field in the form and a field in the Record Source. It works like a dream!!!I have another problem relating to sub-forms. Thanks again for the quick solutions to this problem, I have to learn to ask for help alittle quicker.

Jul 12 '10 #12 reply Expert 100+ P: 1,356 Denburt Did you try ANY of the changes I suggested? their explanation I dont want to believe you will want to take this route. It all depends on how the tables are set up and what you are using to reference them to each other. It's not clear because the original poster did not identify the original error(s), only "i get different errors everytime i try it." Jasmineeyes, I think you were really close originally.

If you are keeping each zipcode then BeforeUpdate, AfterUpdate, and OnChangeevents will be handy to check the entry for correctness of the new zipcode and eliminate duplicates (with BeforeUpdate event), refresh Basically the above 3 Dlookups are the control sources for 3 textboxes on a form. BTW: it's an Access 2013 desktop database, split into FE and BE, both MSA2M13. Posts: 26,373 Thanks: 0 Thanked 2,403 Times in 2,372 Posts Re: DLookup not working I haven't looked at your db but I would imagine you have a ShipmentID field there.

Linq ;0)> CyberCowView Member Profile Feb 26 2013, 11:00 AM Post#7UdderAccess Admin + UA RulerPosts: 19,543Joined: 27-April 02From: Upper MII strongly agree with missinglinq where the use of Reserved Words is Thanks for the effort in helping. I'm stumped. The name of the combo box is PropertyClassNumb (I made it different from the field name in the table for my own clarity).

Join your peers on the Internet's largest technical computer professional community.It's easy to join and it's free. You may have to register before you can post: click the register link above to proceed. This I want to believe if your easiest route.

Anyway, I ran the Quick Repair on Access 2013 and everything is working fine.

Covered by US Patent. If anyone else has the same problem, the correct code should read:txtBuy = DLookup("[PrestigeBuyPrice(exGST)]", "tblJobBULKOrder", "[JobId]=[Forms]![frmOrderInput]![JobNo]" _& " AND ProductDescription = '" & Forms!frmOrderInput!subfrmProduct!cboProductDescription & "'") RE: DLookup Not Working papic1972 One is to use a query with the same criteria as used on the subform, another is to use the subform recordset. RE: DLookup Not Working RoyVidar (Instructor) 8 Apr 04 03:14 Hi again and thanx for the star!To do this, there are a couple of ways.

Maybe put it on the next controls got focus event? Assuming that, I would suggest the form be bound to a query rather than one of the tables. Can we think of the EM tensor as an infinitesimal generator of Lorentz transformations? Connect with top rated Experts 18 Experts available now in Live!

Privacy Policy Site Map Support Terms of Use Register Help Remember Me? Nick Nevsky78 View Public Profile Find More Posts by Nevsky78

01-24-2011, 05:34 AM #7 JANR Newly Registered User Join Date: Jan 2009 Location: Norway Sample code for performing this from the subform where the initial control is:dim rs as dao.recordsetset rs = Forms!frmOrderInput!subfrmProduct.Form.RecordsetCloneif not rs.bof thenrs.movefirstdo while not rs.eofrs.editrs!supplierid=me!cboSupplierrs.updaters.movenextloopend ifset rs=nothing- typed not testedCouple of The only thing that works is if I press F9 OR if I set a requery method on a doubleclick within the field.

If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.Would you like to participate?