Results 1 to 2 of 2

Thread: Forms

  1. #1
    Join Date
    Mar 2004
    Posts
    128

    Unanswered: Forms

    Hi,
    I need your help in the following:
    1. I'm designing a form that disply the LPT data bits in a textbox.
    2. I have a table "Faults" which consist of (Fault_Number,Fault_Code).
    each fault has proper code e.g:1->1102 , 2->1025 ...
    3. the number that I read from the LPT is a number.
    I want to pull out the fault code from the table according the number that I get from the LPT.
    4. the textbox will contains of the code.
    how I can do that?
    please help me...
    best regards...

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Lightbulb

    Quote Originally Posted by wasimf
    Hi,
    I need your help in the following:
    1. I'm designing a form that disply the LPT data bits in a textbox.
    2. I have a table "Faults" which consist of (Fault_Number,Fault_Code).
    each fault has proper code e.g:1->1102 , 2->1025 ...
    3. the number that I read from the LPT is a number.
    I want to pull out the fault code from the table according the number that I get from the LPT.
    4. the textbox will contains of the code.
    how I can do that?
    please help me...
    best regards...

    Use DLookup
    Something like that
    yourTextBox= DLookup("Fault_Code", "Fault", "[Fault_Number] = 100")
    Will pull the fault_code for the Fault_Number 100 (taking into consideration that it is numeric) from the table Fault...

Posting Permissions

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