Results 1 to 2 of 2
  1. 06-08-2011, 07:23 AM #1
    kman42
    kman42 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    40

    Way to not show new record line in subform?

    I have a subform that displays as a datasheet. It is only for displaying the related records and providing navigation to those records (the user can click on hyperlinked text in a row to go to a different form showing the complete related record).



    Is there any way to prevent the subform from showing the 'new' record at the end of the list in the data sheet? I don't want users to add records directly in the subform.

    Thanks,
    kman
    Reply With Quote Reply With Quote
  2. 06-08-2011, 07:30 AM #2
    nicknameoscar
    nicknameoscar is offline Advanced Beginner
    Windows XP Access 2000
    Join Date
    Apr 2011
    Location
    Earlysville, VA
    Posts
    91
    In Form Properties, Data tab set "Allow Additions = No"

    Does that do what you want?
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Show Recordset in unbound subform
    By vgarzon in forum Forms
    Replies: 4
    Last Post: 03-02-2011, 04:11 PM
  2. Show only current record in report from form/subform
    By stelioshania in forum Reports
    Replies: 0
    Last Post: 03-02-2011, 02:19 PM
  3. Subform will not show data
    By Brian62 in forum Forms
    Replies: 2
    Last Post: 02-19-2010, 10:43 AM
  4. Show all recordset in form/subform
    By Brian62 in forum Forms
    Replies: 4
    Last Post: 11-04-2009, 11:56 AM
  5. How to show new record at the top of a subform
    By kabichan in forum Access
    Replies: 4
    Last Post: 10-29-2008, 11:53 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums