[AccessD] Dang Bound Forms Again

Rocky,

<<If I remove the recordsource I get the form but the bound fields have
#Name
in them because they're bound to unknown fields.>>

 Well don't do that<g>.  If you want the form blank, either put a filter
condition on it that returns no records or set the DataEntry property to
True.

Jim Dettman
President,
Online Computer Services of WNY, Inc.
(315) 699-3443
jimdettman at earthlink.net

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Rocky Smolin -
Beach Access Software
Sent: Wednesday, June 04, 2003 2:28 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Dang Bound Forms Again


Charlotte:

When there are no records in the recourd source the form comes up blank.

If I remove the recordsource I get the form but the bound fields have #Name
in them because they're bound to unknown fields.
----- Original Message -----
From: "Charlotte Foust" <cfoust at infostatsystems.com>
To: <accessd at databaseadvisors.com>
Sent: Wednesday, June 04, 2003 10:28 AM
Subject: RE: [AccessD] Dang Bound Forms Again


> Why would you get #Name? Stuff with an empty table?  If the form is
> bound, it's bound to the fields, whether there is anything in them or
> not.  If you are binding the form when you open it, use a default empty
> recordset (i.e., WHERE 1=2), which will eliminate the #Name error but
> still give you empty bound fields.  You would have to change the
> recordsource in code, but I generally use an empty recordset as the
> default recordsource to make my forms load faster.
>
> Charlotte Foust
>
> -----Original Message-----
> From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com]
> Sent: Wednesday, June 04, 2003 8:50 AM
> To: AccessD at databaseadvisors.com
> Subject: [AccessD] Dang Bound Forms Again
>
>
> Dear List:
>
> I have a bound form which displays product structures.  If the product
> structure table is empty (as it would be when the user is just starting
> up) the screen comes up blank.  I would like the form to display empty
> without the #Name stuff, of course.
>
> How do you all solve this problem of a bound form bound to an empty
> record source?
>
> MTIA
>
> Rocky Smolin
> Beach Access Software
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


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