Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    16

    Unanswered: second column from a combo

    Hi,

    I have a problem with my report. In the report I would like to have a value of a combo which origins from the opened Form. However, the combo in a form consists of two columns: first named ID and second named NAME (and the first one is invisible). I would like my report to have only the value of column NAME and I'm not sure how should I get in there.

    Thank you very much for any advices,

    Greetings,
    Pawel

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by pdudzik
    Hi,

    I have a problem with my report. In the report I would like to have a value of a combo which origins from the opened Form. However, the combo in a form consists of two columns: first named ID and second named NAME (and the first one is invisible). I would like my report to have only the value of column NAME and I'm not sure how should I get in there.

    Thank you very much for any advices,

    Greetings,
    Pawel
    And where are you gonna put it in your report???

    You access non-bound columns of a combobox by:

    SomeCombobox.Column(XXX,SomeCombobox.ListIndex)

    And to access it from a form:

    Forms![FormNameHere]!SomeCombobox.Column(XXX,SomeCombobox.ListIndex)
    Back to Access ... ADO is not the way to go for speed ...

Posting Permissions

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