[AccessD] Set form recordsource on Load event without records

Dan Waters dwaters at usinternet.com
Wed Jan 16 18:54:45 CST 2008


I have a continuous form that has bound fields in the Detail section.

On Load, I want the detail section to show no records, and not show #Error
in the bound fields.

I can:

1) 'SELECT X FROM table WHERE ID = 0', but that's a hit on the BE.

2) Set Me.Recordsource = "", but then I get #Error.

3) Create a FE table with correct fields and no records, but that's another

   FE object with only one simple purpose.


Is there another way to do this?

Thanks!
Dan




More information about the AccessD mailing list