Undesired parameters requests in nested datasheets with comboboxes

[Federico Caselli]

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_PrimoLivello!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.

 

[John W. Vinson]

On Tue, 27 Apr 2010 01:50:04 -0700, Federico Caselli <Federico

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.