Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Mar 2001
    Location
    Atlanta, Georgia, USA
    Posts
    64
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Form 'forgets' the previous records (Access 2000, SP1)

    I have a form that is being executed directly from a switchboard, and while I am working on the form, I can go forward and backward, looking at the records. Yet when I exit the database and go back in, I can't see the records. The form is linked to a table, and I can go into the table and see the records. Is this just a newbie error?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Form 'forgets' the previous records (Access 2000, SP1)

    Check these possibilities:
    <UL><LI>The form is being opened by the switchboard in Add mode instead of Edit mode. To check this, use the Switchboard Manager (Tools/Database Utilities), and see what command is associated to the item that opens the form.
    <LI>The form is set to allow creating new records only. Open the form in design mode. In the Data tab of the Properties window, look at the value of DataEntry. If it's set to Yes/True, the form will not display existing records.[/list]If this doesn't solve the problem, post back.

  3. #3
    Star Lounger
    Join Date
    Mar 2001
    Location
    Atlanta, Georgia, USA
    Posts
    64
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Form 'forgets' the previous records (Access 2000, SP1)

    It was the second item you mentioned. Thanks!

    Brian

Posting Permissions

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