What is syntax for sub subform's sourceobject?

[Galaxiom]

Chris's advice re error handling aligns with my own. I usually add error handlers at the end using MZ-Tools (a free and must have tool for every VBA developer) and comment out the On Error line for later rework.

Chris's suggestion about using a constant should be taken a step further if you want to persue that technique.

Investigate conditional compilation. It is special type of If statement that only includes the True branch when the code is compiled. This ultimately results in more efficient code on the production database.

 

[LisaOnMSN]

New knowledge is good knowledge. My thanks.

Lisa

 

[boblarson]

I did get it all to work yesterday on my way home on the bus. But since I was using Access 2010 for it, you wouldn't be able to use it unless you were using Access 2010.

I'm pretty busy today (lots of problems showing up today that I'm having to troubleshoot here at work but I will attempt to detail the problems I found (including wrong references to the wrong form, naming issues - names in the lookup table that didn't correspond with what you were looking for, etc.)

 

[LisaOnMSN]

Appreciate all the effort.