<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Jeffery:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I tried that. The problem is that if I set
the recordsource to nothing the form comes up with all those #Name
thingies. And then if I do a NewRec I get and error that says I can't
assign a value to a bound text box. :(</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Rocky</FONT></DIV>
<DIV><FONT face=Arial size=2>. </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=jeffrey.demulling@usbank.com
href="mailto:jeffrey.demulling@usbank.com">jeffrey.demulling@usbank.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, June 04, 2003 10:09
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [AccessD] Dang Bound Forms
Again</DIV>
<DIV><BR></DIV><BR><FONT face=sans-serif size=2>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%">
<TBODY>
<TR vAlign=top>
<TD>
<TD><FONT face=sans-serif size=1><B>"Rocky Smolin - Beach Access
Software" <<A
href="mailto:bchacc@san.rr.com">bchacc@san.rr.com</A>></B></FONT>
<BR><FONT face=sans-serif size=1>Sent by: <A
href="mailto:accessd-bounces@databaseadvisors.com">accessd-bounces@databaseadvisors.com</A></FONT>
<P><FONT face=sans-serif size=1>06/04/2003 11:49 AM</FONT> <BR><FONT
face=sans-serif size=1>Please respond to accessd</FONT> <BR></P>
<TD><FONT face=Arial size=1> </FONT><BR><FONT
face=sans-serif size=1> To:
AccessD@databaseadvisors.com</FONT> <BR><FONT
face=sans-serif size=1> cc:
</FONT> <BR><FONT face=sans-serif size=1>
Subject: [AccessD] Dang Bound
Forms Again</FONT></TR></TBODY></TABLE><BR><BR><BR><FONT face=Arial
size=2>Dear List:</FONT> <BR><FONT face="Times New Roman" size=3> </FONT>
<BR><FONT face=Arial size=2>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
face="Times New Roman" size=3> </FONT> <BR><FONT face=Arial size=2>How do
you all solve this problem of a bound form bound to an empty record
source?</FONT> <BR><FONT face="Times New Roman" size=3> </FONT> <BR><FONT
face=Arial size=2>MTIA</FONT> <BR><FONT face="Times New Roman"
size=3> </FONT> <BR><FONT face=Arial size=2>Rocky Smolin<BR>Beach Access
Software</FONT> <BR><FONT face="Times New Roman" size=3> </FONT><FONT
face="Courier New"
size=2><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>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BODY></HTML>