[AccessD] Set form recordsource on Load event without records

If you give it an impossible condition, then it won't show #Error when
you first open and your fields will still be bound.  For example,
"Select * FROM table WHERE 1 = 2" will immediately load the form empty
without errors and without a trip to the database.  

Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Wednesday, January 16, 2008 4:55 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Set form recordsource on Load event without records

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

--