Results 1 to 6 of 6
  1. #1
    Dannat is offline Novice
    Windows 7 32bit Access 2002
    Join Date
    Jan 2012
    Posts
    18

    [Solved] Form returning last blank table row

    I have a form that takes the users input and return the information correctly in multiple rows but it also includes the last blank row of the table. If the user types last name it will return the information but also display the last row being empty except for "#Name?" being in the last name field. How do I get rid of this?
    Last edited by Dannat; 01-30-2012 at 08:34 AM. Reason: solved

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    The user input is into an unbound control used to filter/goto record? Form is in Continous view? If you want to allow users to enter a new record, need to allow that 'blank' row. That is the new record row. There is an expression with a reference that Access can't resolve. What are the properties of the Last Name field in table and the bound control?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Dannat is offline Novice
    Windows 7 32bit Access 2002
    Join Date
    Jan 2012
    Posts
    18
    The user does not input new data, the user inputs a name and the records are then displayed with the name entered. The issue is that if the user types smith, 3 smiths will come up as well as that last blank row. I want that final row to not be displayed only the 3 smiths.

  4. #4
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Try setting the form's Allow Additions property to False
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  5. #5
    Dannat is offline Novice
    Windows 7 32bit Access 2002
    Join Date
    Jan 2012
    Posts
    18
    That did it. Man something so simple, I feel like an idiot. Thank you so much. How do I mark this thread as solved?

  6. #6
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Glad that worked for you.

    To mark it solved:
    Page up to the start of the thread and click on thread tools. then select the solved option.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

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

Similar Threads

  1. Blank Field returning #Error
    By imintrouble in forum Access
    Replies: 8
    Last Post: 12-09-2011, 03:00 PM
  2. Recordset returning blank value
    By Mohamed in forum Access
    Replies: 1
    Last Post: 10-24-2011, 09:31 AM
  3. Replies: 1
    Last Post: 10-20-2011, 07:37 AM
  4. Replies: 4
    Last Post: 05-11-2011, 03:06 AM
  5. Replies: 1
    Last Post: 08-27-2010, 05:16 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