Displaying of new records

Ask a Question related to Microsoft Access, Design and Development.

  1. #1

    Default Displaying of new records

    How do you display a NEW record upon entry into a form? It
    always shows me the LAST record. I want the default to be
    a NEW record. Thanks!
    MMB Guest

  2. Similar Questions and Discussions

    1. displaying dup records
      I need to create a list of records that are within the same file that are duplicate records. I wanted to display any records that match another...
    2. Displaying Records
      Hello All, Finally was able to connect my access database to DW, now I'm trying to display the record set in DW. After adding the table?s column...
    3. displaying the last 5 records
      Hi, I want to display the last 5 or 10 records, for example a table with 50 records but i just want to get and display the last 5 records of the...
    4. Displaying Records Horizontally
      I understand how to use the 'repeat region' server behavior to display records horizontally as opposed to vertically, however i'm not sure how to...
    5. help with displaying records - please
      My SQL Statement under my recordset is: SELECT mmatter, (feest+costst)-(arwofft+oafeest+paymentt) as balance FROM dbo.ken_juantable WHERE...
  3. #2

    Default Re: Displaying of new records

    Open the form in design view. Open the Properties sheet. On the Data tab set Data Entry to
    Yes, this will only allow new records to be entered.

    --
    Wayne Morgan
    Microsoft Access MVP


    "MMB" <mmbopp@uams.edu> wrote in message news:02a601c34b09$8f1b3660$a401280a@phx.gbl...
    > How do you display a NEW record upon entry into a form? It
    > always shows me the LAST record. I want the default to be
    > a NEW record. Thanks!

    Wayne Morgan Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139