[AccessD] Dang Bound Forms Again

Hello Rocky,

Firstly, I could not imagine what you form was looking like, so, I just created a new db, created one table and entered no data at all.  I then allowed the form wizard to create a new form.  It opens perfectly and displays the three fields that I created.  I can now add a new record if I wish.  So, if this your scenario, if so, why are you getting #name.  

I think that I have experienced #name when the record source is not opening perhaps due to an SQL error in the record source, is this possible?

The other alternative is, you are hinting that there is a product structure.  I am wondering whether you have a one to many relationship and the many side is empty.  If this is the case, could you consider making it a left outer join?  I.E., 

    (
    show me all the product codes, and any of their properties if a property exists, 
    if not, do please show me the product code anyway, 
    thank you.
    )

If I am completely on the wrong track, please delete my email quickly and never think about it again,

Mark




  ----- Original Message ----- 
  From: Rocky Smolin - Beach Access Software 
  To: AccessD at databaseadvisors.com 
  Sent: Wednesday, June 04, 2003 5:49 PM
  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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030605/6e7c5dc5/attachment-0001.html>