Is this a stupid question?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Lynx101
    #1

    Is this a stupid question?

    Hi, Is this a stupid question?

    Senario: Two tables linked together with an ID number.

    Question: When using a combo box, which refences another table by
    indexed autonumber, is there a way to copy the returned text value to
    a text field. I have many combo boxes and after the value changes I
    would like a normal text field to show the returned text value,
    regardless of which combo box was changed.

    A little like the "paste as values" option in excel if you know what I
    mean.

    Thanks
    Matt
    Tags: None
    • Arno R
      #2
      Re: Is this a stupid question?


      "Lynx101" <mattcolenutt@g mail.comschreef in bericht news:e2726f87-1246-4dea-94c2-6de3312cd893@2g 2000hsn.googleg roups.com...
      Hi, Is this a stupid question?

      Senario: Two tables linked together with an ID number.

      Question: When using a combo box, which refences another table by
      indexed autonumber, is there a way to copy the returned text value to
      a text field. I have many combo boxes and after the value changes I
      would like a normal text field to show the returned text value,
      regardless of which combo box was changed.

      A little like the "paste as values" option in excel if you know what I
      mean.

      Thanks
      Matt
      Not a stupid question, but a 'unclear' question (to me)
      So I am not sure I understand what you are asking...

      You are having "many combo boxes" ...
      When "the value" changes (what value ??) ...
      you want the "returned text value" (you mean the value of the choosen item in the combo ??) ...
      to show in a normal text field somewhere ???

      IIUC then you need something like this code in the afterupdate event of the combo's
      Me!NormalTexTFi eld=Me!ThisComb oName.Column(0)

      Arno R

        Comment

        • Lynx101
          #3
          Re: Is this a stupid question?

          yes sorry about that.

          You have hit this one on the head. I've used your method and it works
          perfectly. Really appreciate (1) decoding my initial request (2)
          finding a perfect solution.

          Many thanks
          Matt

            Comment

            Previous template Next
            Working...