Subform multiple items selection problem

[miguelsbpgj]

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

 

[jmrSudbury]

1 - It allows me to select any of the 3 items in the ProblemaID subform. I can select them as many times as I like. It also allows me to select 1,2 or 3 for the subSistemasYProblemasAnteriores subform. I don't understand what the problem is.

2 - Your column count is 1 and you are set to using datasheet view instead of form view for the sub forms. Change your query to this:

SELECT tblProblemas.Problema, tblProblemas.ProblemaID
FROM tblProblemas;

Next bind the combo box to the second column instead of the first. Of course, this may change your limit to list setting.

John M Reynolds