Thanks Marcia for your response and congratulations for your article in F.P.Advisor.No, the grid is empty and when I executed the view it works fine.
The variable contains the right value in a numeric format.I´m working with integer values,that is : id_client (is in integer format).When I check it in the debugger it shows the correct value but nothing happens.If I´m working with two views should I index both in a particular format ?
These two views relies on two tables (Clients and Payments).In my form I have one control for the ID,one for the LastName and one for the FirstName and then, below the Grid.I built a commandbutton(called cmdFind) to select the client.A listbox fires when the user clicks the button.I put there the second view because it contains fields of two different tables.Then when the user selected the client, the LastName,FirstName and the ID appears in the form.But the grid is always empty.
How can I do ?
Thanks in advance