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

    Thumbs up Unanswered: Gathering multiple fields and combining values onto one field

    I made a form with two unbound List box and one unbound text box. I am going to use these controls to make a identification number on tblSomething.

    I know this is a really newbie question, but this is the first time I had to do this. Please show me some examples including listbox and textbox.

  2. #2
    Join Date
    Jul 2003
    Canberra, ACT Australia
    if you place something similar to the following in as the control source for a text box, and then use that concatenated control source to put into your idfield in table Something it should help.

    =[List1].column(x) & [List2].column(y) & [Text1]

    In this case List1 and List2 are your list boxes, and colums x and y are the various columns that may be used for example ina multicolumn list box. The column numbers may/may not be the same - it doesn't matter, and Text1 is your text box with its contents.

    Note the placement of and difference between the [] and ().

    You will use the appropriate names for the controls on your form. For example if your first listbox field is named 'phonenum' and your second listbox field is called 'firstname' then the control source will be:

    =[phonenum].column(2) & [Firstname].column(2) & [Text1]

    hope this 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