Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Location
    Malaysia
    Posts
    7

    Talking Unanswered: need help again- auto fill in after do a Vlookup

    haii...all my friends here... please help me to solve my program..

    I have created two tables containing the SALARY and DEDUCTION TABLE . In the SALARY table i created 2 fieldname call 'Salary' and 'Salary Deduction'. For the DEDUCTION TABLE i had 2 fieldname call 'Salary Range' and 'Sum of Deduction'.
    My problem is,
    i want fieldname 'salary deduction' automaticly do a Vlookup to DEDUCTION table and auto fill in to the fieldname Salary deduction.

    see attachment for a clear view.

    Please help me on this

    TQ
    Attached Files Attached Files

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    465
    I can't see your base because i have Access 97 but why dont use the
    Dlookup sentence some thing lile this to obtain your data:

    Dim varX As Variant
    varX = DLookup("[Sum of Deduction]", "DEDUCTION", "['Salary Range] ....your criteria.....")
    Me![salary deduction] = varX
    Saludos
    Norberto

  3. #3
    Join Date
    Oct 2003
    Location
    São Paulo - Brazil
    Posts
    91
    Originally posted by Norberto
    I can't see your base because i have Access 97 but why dont use the
    Dlookup sentence some thing lile this to obtain your data:

    Dim varX As Variant
    varX = DLookup("[Sum of Deduction]", "DEDUCTION", "['Salary Range] ....your criteria.....")
    Me![salary deduction] = varX
    Hi!

    You should´t store a calculated value in your table: you´ll have lots of trouble in the future.
    My environment: Windows XP/ Access 2000 - Using Microsoft DAO 3.6 Library

Posting Permissions

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