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. |
#2
|
|||
|
|||
Undesired parameters requests in nested datasheets with comboboxes
On Tue, 27 Apr 2010 01:50:04 -0700, Federico Caselli Federico
wrote: Hi, I have some nested datasheets. The subdatasheets have comboboxes used as lookup. The combo sql code is a little complex, like: Use Forms instead. They give you much more control and should avoid these errors. Microsoft is really pushing table datasheets as a user interface, but it's a *really limited* user interface; there's been a better option since Access 1.0. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|