Results 1 to 8 of 8
  1. #1
    grad2009 is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2010
    Posts
    27

    the message #Name? in the text

    hello guys,
    i created a form with the form design then i dragged the text box tool in it, after that in the Control Source property of the text box i chose one field from an existed table, then when i open it in the form view this message (#Name?) in the text box.
    can you tell me what's the problem?


    thanks,

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    It sounds like you did not select a RecordSource for your form.

  3. #3
    grad2009 is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2010
    Posts
    27
    thanks alot RuralGuy
    but when i open the form in the in the form view it appears as a blank page ( i mean the textbox doesn't appear in the view).

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    It sounds like you have to existing records and AllowAdditions is set to NO.

  5. #5
    grad2009 is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2010
    Posts
    27
    thanks a lot RuralGuy
    i got more information from the following website
    http://allenbrowne.com/casu-20.html

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Excellent! Thanks for the update. Do you care to share your particular solution with others that read this forum?

  7. #7
    grad2009 is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2010
    Posts
    27
    Welcome


    Do you care to share your particular solution with others that read this forum?
    maybe i didn't understand what do you mean exactly, but of course i want every body to get benefit.

  8. #8
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Are you saying that my post #4 solved your issue? I thought maybe there were some more issues that Allen's page helped you resolve.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. SendObject Message
    By williammarino in forum Forms
    Replies: 4
    Last Post: 10-06-2009, 01:54 AM
  2. Text too long, error message
    By taylormotm in forum Access
    Replies: 13
    Last Post: 06-18-2009, 07:24 PM
  3. message box help
    By shaz10010 in forum Forms
    Replies: 1
    Last Post: 04-17-2009, 09:11 AM
  4. Message in Field
    By supatsiri in forum Reports
    Replies: 0
    Last Post: 03-09-2009, 01:59 AM
  5. If / Then Error Message
    By Schwagr in forum Forms
    Replies: 4
    Last Post: 03-30-2006, 06:28 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums