[AccessD] Set form recordsource on Load event without records

Assuming that ID is the PK of the table, then choice 1 is a very minimal hit
on the BE, since the index will quickly deduce that no key matches. I might
even adjust the query to PK < 0 (thinking about Colby's and others' use of
the zeroth record).

Arthur

On 1/16/08, Dan Waters <dwaters at usinternet.com> wrote:
>
> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>