Hi everyBody, I Want to know ho

[nadjib]

Hi everyBody,

I Want to know how can I change, or accede (from VBA) to the :
form -> Propriety -> Data -> Sourrce -> SQLCODE

In fact, I want to make dynamic my SQLCODE Query. So I want change :

SOURCE -> SQLCODE = SELECT [Forms name].[fields name] FROM [Forms name];"

To
'at each time I insert the name of the table
strSQL1 = InputBox$(TitreInputBox, "Acquisition of data&quot
SQLCODE= "SELECT [" & StrSQL1 & "].NumSugg FROM [" & StrSQL1 & "];"


So I want to know the syntax must I use to excute the SQLCODE

cordially

nadjib