<br><font size=2 face="sans-serif">Why not check the number of records in the record source first and if there are none then set the recordsource to nothing otherwise have the recordsource set to your recordsource. If you want some sample code I can give it to you.</font>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td>
<td><font size=1 face="sans-serif"><b>"Rocky Smolin - Beach Access Software" <bchacc@san.rr.com></b></font>
<br><font size=1 face="sans-serif">Sent by: accessd-bounces@databaseadvisors.com</font>
<p><font size=1 face="sans-serif">06/04/2003 11:49 AM</font>
<br><font size=1 face="sans-serif">Please respond to accessd</font>
<br>
<td><font size=1 face="Arial"> </font>
<br><font size=1 face="sans-serif"> To: AccessD@databaseadvisors.com</font>
<br><font size=1 face="sans-serif"> cc: </font>
<br><font size=1 face="sans-serif"> Subject: [AccessD] Dang Bound Forms Again</font></table>
<br>
<br>
<br><font size=2 face="Arial">Dear List:</font>
<br><font size=3 face="Times New Roman"> </font>
<br><font size=2 face="Arial">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.</font>
<br><font size=3 face="Times New Roman"> </font>
<br><font size=2 face="Arial">How do you all solve this problem of a bound form bound to an empty record source?</font>
<br><font size=3 face="Times New Roman"> </font>
<br><font size=2 face="Arial">MTIA</font>
<br><font size=3 face="Times New Roman"> </font>
<br><font size=2 face="Arial">Rocky Smolin<br>
Beach Access Software</font>
<br><font size=3 face="Times New Roman"> </font><font size=2 face="Courier New"><br>
_______________________________________________<br>
AccessD mailing list<br>
AccessD@databaseadvisors.com<br>
http://databaseadvisors.com/mailman/listinfo/accessd<br>
Website: http://www.databaseadvisors.com<br>
</font>
<br>
<br>