A
Alain
Hello
I have the following request written in the source property of my sub form
SELECT [Sociétés].[Société],[Contacts].[Nom], [Adresses].[Adresse]
FROM (Sociétés INNER JOIN Adresses ON [Sociétés].[RéfSociété] =
[Adresses].[RéfSociété]) INNER JOIN Contacts ON [Adresses].[RéfAdresse] =
[Contacts].[RéfAdresse]
WHERE ((@AdresseCourante=[Contacts].[RéfAdresse]))
ORDER BY [Contacts].[Div/Dépt], [Contacts].[Nom], [Contacts].[Prénom]
I have written in the Input parameter field of my Sub form :
@AdresseCourante=forms![form_societe]!AdresseCourante
When I open my sub form I have the following message :"The parameter
@AdresseCourante must be declared "
What should I do to declare my Parameter ?
best regards
Alain
I have the following request written in the source property of my sub form
SELECT [Sociétés].[Société],[Contacts].[Nom], [Adresses].[Adresse]
FROM (Sociétés INNER JOIN Adresses ON [Sociétés].[RéfSociété] =
[Adresses].[RéfSociété]) INNER JOIN Contacts ON [Adresses].[RéfAdresse] =
[Contacts].[RéfAdresse]
WHERE ((@AdresseCourante=[Contacts].[RéfAdresse]))
ORDER BY [Contacts].[Div/Dépt], [Contacts].[Nom], [Contacts].[Prénom]
I have written in the Input parameter field of my Sub form :
@AdresseCourante=forms![form_societe]!AdresseCourante
When I open my sub form I have the following message :"The parameter
@AdresseCourante must be declared "
What should I do to declare my Parameter ?
best regards
Alain