Déclaration missing for my parameter

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top