Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2007
    Posts
    4

    Unanswered: Subform multiple items selection problem

    Hello to all ...

    Could you help me with the attached file ?

    I tried to reproduce the multiple selection subform with the " ProblemaID " field at the end of
    " frmClientesParticulares " at its right side with the name " subSistemasYProblemasAnteriores "
    but there are two errors :


    1 - Every first time I open " frmClientesParticulares " I can select one item from

    " ProblemaID " field ( on " subSistemasYProblemasAnteriores " ) but only at this

    1st time, next item I try to select MS Access says that there must be a related

    field at tblSistemas


    2 - The items I can select are always its numbers ( ProblemaID from tbl Problemas ) and

    not the items itself ( the entered items for each ProblemaID number ) .



    Can you help me to find what is wrong ?



    Please, you are free to modify anything but don't forget to explain exactly what you've done to turn things working, otherwise my MS Access knowledge will not be " increased " .

    Lots of thanks in advance,

    Miguel
    Attached Files Attached Files

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    I think this is your second post for the same question?

    Please try and clarify your problem. I don't quite follow what it is that's going wrong here...

    I have been unable to re-create your error!
    George
    Home | Blog

  3. #3
    Join Date
    Feb 2007
    Posts
    4
    Hi georgev

    You said : " I have been unable to re-create your error! "

    Problem is : At the end of " frmClientesParticulares " when you select an item from " ProblemID" table at the left, the problem name appears ( and that's what I want ) but, if you try to do the same at the table at right ( that is only an experiment to see if I can successfully reproduce the left table to apply the concept to other dbs ) is the problem number that apears instead of the problem name .
    Did you saw this ?

    This is what is wrong .

    And yes, it is the secound time I'm talking about the same because I was
    calling multiple selection combobox to a thing that is in reality a multi selection subform .


    Thanks again,

    Miguel

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Ok, I'm still not getting my head round this...

    Do you want your combobox to display multiple columns in one table?

    Eg: table1(field1, field2, field3)

    Combobox shows | field1 | field2 | field3 |
    George
    Home | Blog

Posting Permissions

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