Access - Step Through of code works - Run through doesn't

[Kenton]

Gudday

I am calling a form from another form in Access and trying to populate a couple of fields on the second form from the first.

The problem is, the second field doesn't get populated except when stepping through the code!?!?

viz:
stDocName = "Actions"
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.GoToRecord , stDocName, acNewRec
Forms("Actions&quot.Cams_ID = Forms("faults&quot.[CamsNumberText]
Forms("Actions&quot.old_sts_id = Forms("faults&quot.[Status_id]

4th line (Cams_ID) works, 5th line doesn't when run through.
BUT Both lines work fine when stepped through.

Any ideas?
Kenton

 

[zemp]

Just a guess, but it might have to do with the speed of execution. I mean when you are stepping through the 4th line then database has time to update itself (looks like you are adding a new record, this takes more time than an update). When you are running the code it may not have the time it needs and the 5th line fails. You may need to add something like a doevents or use the beforeinsert or afterinsert events.

Thanks and Good Luck!

zemp

 

[Kenton]

Thanks

I found it.

It seems the screen wasn't being refreshed. If I dragged a window across the field the data would appear.

Kenton