Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    58

    Unanswered: Dynamic Text Box

    I have a query that is layed at something like this:

    IDNo A_Value B_Value C_Value D_Value E_Value F_Value Code
    0001 1 2 3 4 5 6 A
    0001 1 2 3 4 5 6 B
    0001 1 2 3 4 5 6 C
    0001 1 2 3 4 5 6 D
    0001 1 2 3 4 5 6 E
    0001 1 2 3 4 5 6 F
    0002 6 5 4 3 2 1 A
    0002 6 5 4 3 2 1 B
    0002 6 5 4 3 2 1 C
    0002 6 5 4 3 2 1 D
    0002 6 5 4 3 2 1 E
    0002 6 5 4 3 2 1 F

    On the report this query is linked to it is grouped by the Code field so all lines with a code of A is listed on one page, however for each section I only need to display the value from one of the *_Value fields (the field that partially contains the Code value, ie: the Page that lists all the A Codes needs to display the value from the A_Value field, the B page=B_Value, etc).

    Is there a way I can have a text box that dynamically changes it's record source to the relevant field for each group section?

  2. #2
    Join Date
    May 2005
    Posts
    1,191
    Quote Originally Posted by HilcrRWise
    Is there a way I can have a text box that dynamically changes it's record source to the relevant field for each group section?
    No, or at least not that I'm aware of. You could try changing the query the recordsource is based on to be smarter using IIF functions and what not.
    Me.Geek = True

Posting Permissions

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