Question For Loop not intialzed

[Joe8915]

Now what did I do wrong. I created a new forum. Tried to use the Wizard for creating a sub form then I got a message "For Loop not initialized". I’m running 2007 with a split SQL running in the BE.
Any ideas or thoughts would help.
Thanks

 

[Guus2005]

Impossible to tell when the actual code is unknown.

 

[Joe8915]

Guus, Sorry I have not reported back as soon as I should have. I have SQL running as my BE. I was adding new fields to previous tables and adding new tables as well. I refresh my tables where I added the new fields, then used the wizard to add the new tables to the BE. Then I noiced I added more fields to other tables. So then I just refreshed all the tables. I think that is where I screw up as far as I can tell. The best thing I did, I made a COPY of the DB prior before all the updates. Then I just work backwards and solve the issue. Never did figure out what happen, but all is good now. BACKUP BACKUP BACKUP. What can I say more often.

 

[Guus2005]

Glad you got things working again thanks to AWF (or just common sense).

Share & Enjoy!