Results 1 to 7 of 7
  1. #1
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    listbox (2002 SP-2)

    I
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: listbox (2002 SP-2)

    The list box lstTeams should be unbound. Is the combo box cboTeamAssign bound to a field?

  3. #3
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Re: listbox (2002 SP-2)

    Yes, txtTeamAssign. I use that entry to show which Teams are assigned to which records (and for grouping reports).
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: listbox (2002 SP-2)

    If the combo box is bound, its value will change with each record, so it seems reasonable that the contents of the list box will change too. Or am I missing something?

  5. #5
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Re: listbox (2002 SP-2)

    No more than me friend. You are correct; the como changes with each record, but the list box stays with whatever the last entry was in the combo (and all records reflect that change). There are no table relationships. . .hmmm
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: listbox (2002 SP-2)

    You should also requery the list box in the On Current event of the form.

  7. #7
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Re: listbox (2002 SP-2)

    Well done ol' boy! <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>
    That was the trick!
    Hey! I just noticed you're an "A" now (instead of an "M").
    Wow! I'm honored! <img src=/S/hailpraise.gif border=0 alt=hailpraise width=27 height=22>
    Thanks again for the help!
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

Posting Permissions

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