Code works when debugging only

[Leah.Austin]

I'm trying to replicate data for a new record in a subform by using SQL
SELECT. The code works perfectly when I step through the code in, but
does not work without the debugger. Any ideas?

 

[Allen Browne]

The fact that it works when you single-step through the code indicates there
is a timing problem here.

What event are you using to execute this code? Click of a button? Keypress
of a textbox?

What is in the SQL string? Does it refer to a text box on your form such as
[Forms].[Form1].[Text0], where the value may not be up to date yet?

Is there any chance the record in the subform may not be saved yet? Try
explicitly saving.