Results 1 to 5 of 5
  1. #1
    Join Date
    May 2015
    Posts
    8

    Answered: Displaying record in a form

    Having problems with getting the form to display all the records in the current database. When I look in the table it shows the records. But in the form is only shows the current record or and records that have been add at that time. When I close the form and reopen the form it says showing record 1 of 1. Is there a way through vba to correct this problem with the form. I have check is there is not filter set.

  2. Best Answer
    Posted by Missinglinq

    "From your description (since you don't mention opening your Form from another Form) you almost surely have the Form's Data Entry (Properties - Data - Data Entry) set to Yes, as healdem has guessed; just change it to No.

    Common sense would dictate that Data Entry) has to be set to Yes in order to...enter data; but that's not true! Set to Yes, this Property means that you can only enter/display New Records!

    Linq ;0)>"


  3. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Check the style / type of form you are using
    i forget the access terminology, but i suspect you are using additions / data entry
    I'd rather be riding on the Tiger 800 or the Norton

  4. #3
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    From your description (since you don't mention opening your Form from another Form) you almost surely have the Form's Data Entry (Properties - Data - Data Entry) set to Yes, as healdem has guessed; just change it to No.

    Common sense would dictate that Data Entry) has to be set to Yes in order to...enter data; but that's not true! Set to Yes, this Property means that you can only enter/display New Records!

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  5. #4
    Join Date
    May 2015
    Posts
    8
    Thanks that fixed it.

  6. #5
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Glad we could help!

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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