Just getting started, help

P

Peterbase

I'm a newbie to Access, I'm learning it so i can help a family friend
better manage thier data - Anyway I've created a basic DB for them, and
I'm having a problem finding records from a Form view.. It only shows 1
available record ..



If i enter a few records, i can then go back and use Find to call up the
records in Form View no problem, but as soon as i close outta Form View
and then Reopen it - the records are then gone in Form View.

The records exist in the Tables but they just don't show in Form View,
any help appreciated, TIA ...



-Pete
 
R

Rick Brandt

Peterbase said:
I'm a newbie to Access, I'm learning it so i can help a family friend
better manage thier data - Anyway I've created a basic DB for them, and
I'm having a problem finding records from a Form view.. It only shows 1
available record ..



If i enter a few records, i can then go back and use Find to call up the
records in Form View no problem, but as soon as i close outta Form View
and then Reopen it - the records are then gone in Form View.

The records exist in the Tables but they just don't show in Form View,
any help appreciated, TIA ...

You've got the DataEntry property of the form set to True. In this mode, it is
only used for adding records, not looking at existing ones. Open the form in
design view and look for this property on the Data tab of the property sheet.
Once that is changed the form will show all records when opened.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top