Populating variable with SQL statement

[Guest]

The code below creates a table. Is it possible to populate a variable
instead ?

Dim intRecCount
DoCmd("Select Count(*) into intRecCount From tblTest")

 

[Sylvain Lafontaine]

Populating a variable? What do you mean exactly?

 

[Robert Morley]

I believe what you want would be the following:

Dim intRecCount As Integer
intRecCount = DCount("*", "tblTest")



Rob

 

[Guest]

That worked. Thank you.

I believe what you want would be the following:

Dim intRecCount As Integer
intRecCount = DCount("*", "tblTest")



Rob