If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Undesired parameters requests in nested datasheets with comboboxes
Hi,
I have some nested datasheets. The subdatasheets have comboboxes used as lookup. The combo sql code is a little complex, like: SELECT Quantita.Id, TB_LookupSecondoLivello.Figlio, TB_LookupSecondoLivello.Padre FROM Quantita, TB_LookupSecondoLivello INNER JOIN TB_PrimoLivello ON TB_LookupSecondoLivello.Padre = TB_PrimoLivello.CodiceArticolo WHERE (((Quantita.Id)=[TB_PrimoLivello].[QuantitaRiparazione]*[Impiego]) AND ((TB_LookupSecondoLivello.Figlio)=[Forms]![TB_Clienti]![TB_Bolle]![TB_RigheBolle]![TB_PrimoLivello]![TB_SecondoLivello]![CodiceArticolo]) AND ((TB_LookupSecondoLivello.Padre)=[Forms]![TB_Clienti]![TB_Bolle]![TB_RigheBolle]![TB_PrimoLivello]![CodiceArticolo])); Many times the user work is interrupted by repeated parameters requests, like: Forms!TB_Clienti!TB_Bolle!TB_RigheBolle!TB_PrimoLi vello!TB_SecondoLivello!CodiceArticolo while expanding rows or refreshing records I have put the db online on our site and some screenshot showing some simple user operation and the message appearing: http://www.ciar.it/download/accessproblem.zip Any help appreciated. |
Thread Tools | |
Display Modes | |
|
|