SQL help

[David222]

I am trying to add a record count to a database.

 

When it does an Insert command,

 

Dim rec as Interger

rec = 000000

 

 

 

code........

code........

 

rec = rec + 1

insert num value (rec)

 

VB errors in rec = rec + 1

 

any ideas