programming parameters for a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I posted this question several months ago and I am finally getting the time
to look at it again. Located below is what I have so far:

Don't I have to declare the table (db) and the field to check. I don't see
that being done in what you have given me. If so, excuse for not knowing VB
as well as I should. Any additional hand holding would be much appreciated.

Thanks-in-advance
 
The code looks good. John write good code.

Don't I have to declare the table (db) and the field to check.
There is a syntax error. It should be:
Don't I have to declare the table (db) and the field to check?

But seriously, folks, Not in the context of this code. If you were
instantiating a recordset to use for this purpose, the answer would be yes;
however, the DLookup has all the information it needs to fine the value and
as for the Currentdb.Execute, Currentdb explicitly delcares that and the
Execute method runs an Action query or executes an SQL statement.
 
Back
Top