Hi,
I am new to ADP's but am ok with MDB's, I have worked out how to a build table in a project and have also got forms to enter data into the tables.
But I am struggling with queries, I have basically got all the fields listed on the view, when I run the view with no criteria all is correct, when I enter a basic criteria (i.e. all records with the same job no 3953) it works ok, all records with that job no come out.
But if I tell it to look at a text box on a form to get the criteria from it returns nothing. Below is what I am using.
LIKE '[Forms]!jobentry!jobno'
Help !!!???!!!
I am new to ADP's but am ok with MDB's, I have worked out how to a build table in a project and have also got forms to enter data into the tables.
But I am struggling with queries, I have basically got all the fields listed on the view, when I run the view with no criteria all is correct, when I enter a basic criteria (i.e. all records with the same job no 3953) it works ok, all records with that job no come out.
But if I tell it to look at a text box on a form to get the criteria from it returns nothing. Below is what I am using.
LIKE '[Forms]!jobentry!jobno'
Help !!!???!!!