+ Reply to Thread
Results 1 to 4 of 4

Need Dlookup from one lookup value get result through 3 tables to different textbox

  1. #1
    Forum Contributor
    Join Date
    07-23-2013
    Location
    bangalore
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    143

    Need Dlookup from one lookup value get result through 3 tables to different textbox

    "Dear Experts

    I have set of data table Dispatchcalls Total Column Field 43,Closedcalls Total Column Field 49 ,CancelCalls Total Column Field 40 and I have forms called ""SearchSerialNo Status "" In the form i designed data wizard forms with multiple textbox and cmd button.

    I want dlookup from ""Entered Serial No"" where Input Value entered and click ""FIND SO's"" cmd button get result from Dispatch,closed,cancel tables

    E.g In the Form First 12 FIELD textboxes Dlookup FROM Table-Dispatchcalls through lookup values of Entered serial No.
    In the Form First 11 FIELD textboxes Dlookup FROM Table-Closedcalls through lookup values of Entered serial No.
    In the Form First 2 FIELD textboxes Dlookup FROM Table-Cancellcalls through lookup values of Entered serial No.

    Find the Zipattachment

    1OnsiteDCC -Msaccess
    2Example.xlsb file is attach of example for understanding my requirement



    thanks in advance"
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010
    Posts
    497

    Re: Need Dlookup from one lookup value get result through 3 tables to different textbox

    any experts could help me out?

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    20,720

    Re: Need Dlookup from one lookup value get result through 3 tables to different textbox

    I think we have discussed this before. You should not have three tables but one table with a field with the status of the calls. I have suggested to you that you learn to normalize your data. Until you do that this is a "ginormous" task that will require great amount of coding and probably little satisfaction. Look to redesign your db to a normalized structure. Look at the reference material I have previous provided you.

  4. #4
    Forum Contributor
    Join Date
    07-23-2013
    Location
    bangalore
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    143

    Re: Need Dlookup from one lookup value get result through 3 tables to different textbox

    Solved!!! Thanks for my experts

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] DLookUp function
    By rmachbitz in forum Access Tables & Databases
    Replies: 4
    Last Post: 07-02-2013, 06:30 PM
  2. Combining IIF and DLOOKUP
    By snoproladd in forum Access Tables & Databases
    Replies: 5
    Last Post: 04-11-2012, 01:15 PM
  3. help with dlookup
    By enhydra in forum Access Programming / VBA / Macros
    Replies: 8
    Last Post: 06-07-2011, 05:35 PM
  4. DLOOKUP AND VLOOKUP IN VBA
    By Souris in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-17-2005, 12:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1