[AccessD] Set form recordsource on Load event without records

Thanks to everyone for your solutions!

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Wednesday, January 16, 2008 6: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

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com