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

    Cool Unanswered: irritating combo boxes

    I have a table of clients. It contents for example:

    1 James Brown
    2 Joe Hetfield
    3 James Hetfield

    Every client has an amount of money. I write it in a form (name and surname of a client is a combo box

    and the amount is a text field):
    20$ James Brown
    40$ Joe Hetfield
    60$ ZONK! - when I set the combo 'name' as James the combo 'surname' automatically sets itself as "Brown"; then when I set 'surname' as Hetfield the 'name' sets itself as "James". I would like to set an amount to James Hetfield by using only 'name' and 'surname'.

    Combo boxes are limited to lists.

    Any ideas?
    Thanks for any help,

  2. #2
    Join Date
    Sep 2003
    MN US
    This thread may help you.

    I think you want to concatenate the name and surname in the combo.

    [name] & " " & [surname] as fullname

    Hope that helps.


Posting Permissions

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