Program gets data when stepping through...

[Joe46]

If I put a break point at the end of a SUB that is populating a database in Access and then viewing the printout in CR all the data shows up.

When I run it without any break points it misses one record in CR although the data is in my database.

 

[Joe46]

I remember having this problem about 4 years ago and it was something simple. I thought then that I would never always remember what I was doing wrong, but "NO!"

I take it no one else has ever came across this situation before?

 

[Joe46]

Okay, even though no one else has had this problem I will post the solution in case it happens to you.

All I had to do before I executed the SQL statement was to put a begin.trans, execute the statement, and then commit.trans

Thanks to anyone that looked at the message and gave it some thought.