Code runs in single Step Mode

[Wes1961]

I have code that when a users clicks on a menu button it will check for some valid data, ask for an input, then open a frm/subform with the forms tied to queries. The subform then cycles thru the records from 1 to # of records.

When I execute this code in single step mode everything works fine and I get the correct number of records in the subform. However, if I just let the code run on its own, I always get 1 (one) record in the subform.

By the way, it worked perfectly earlier, so I am sure as I continue to develop the application I have made a change to cause this.

I know this is vague but I'm at my wits end as how to find the problem.

 

[FancyPrairie]

First thing I would do would be to backup my database, then compact and repair it.

 

[Darrylles]

Hi,

#1 - this kind of thing always gives the impression that the code is 'running too fast' and losing itself - it isn't.
#2 - you say that the sub-form 'cycles' thru' records - how? Is this looping code that you have written? If so - can we see it?
#3 - Fancy's advice is good for starters.

ATB

Darrylle

Never argue with an idiot, he'll bring you down to his level - then beat you with experience. darrylles@yahoo.co.uk