[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