Share via

when using the data entry form data disappears

Anonymous
2012-01-09T13:37:42+00:00

Acces 2007; I teaching myself Access 2007 using Prentice Hall's Office 2007 Introductory. I began by entering the data directly in the table. Then I attempted to enter the next line of data using the Access form. When I click "close" per the instructions, not only does the new data not enter but everything I entered before disappears.

Any ideas?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2012-01-09T16:20:21+00:00

If you set the Data Entry property to Yes and open the form it will not display any previous records.  That is normal.  Set property to No.

Was this answer helpful?

1 person found this answer helpful.
0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ScottGem 68,830 Reputation points Volunteer Moderator
    2012-01-11T15:27:32+00:00

    How do you set the data entry property?

    Its on the Data tab for the form.

    Also check how you are opening the form. If you open the form in Add mode it will exhibit the same behavior.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2012-01-11T13:53:06+00:00

    How do you set the data entry property?

    Was this answer helpful?

    0 comments
  3. ScottGem 68,830 Reputation points Volunteer Moderator
    2012-01-10T16:25:31+00:00

    Did you bind the form to the table? This means that you have set the Recordsource of the form to the table. If you did, then as soon as the record loses focus, the data should be added to the table.

    Was this answer helpful?

    0 comments