Viewing All Records

Sandpiper

Registered User.
Local time
Today, 20:58
Joined
Feb 21, 2006
Messages
55
Hi, can anyone please help me.
I've just set up a form with 2 pages which I can add data into, but for some reason, I can't view all records.
I've tried using the switchboard to add buttons to both add records and view (but they both only add), and i've also set up my own button with the instruction to view all records, but it just won't work.
On the first page the data source is tbl_CompanyInfo, and on the second page, the data source is a subform with the data source tbl_Contacts. The subform will link contacts to the company info via the CompanyID field. I hope that makes sense.
Can anyone please tell me how I can view all of the data via the form.
Thanks very much
 
A form can only display one record a time. To show all records, you can set its Default View to Continous Forms or Datasheet. Continous forms will give you multiple identical forms showing each record on it. Datasheet is like a table-view of your table.

Hope that makes sense.
 
Sorry, I didn't phrase my question properly. What I want to be able to do is use the navigation buttons at the bottom of the screen to move between records on the form. I have had this problem before with a different database, where I can only view the most recently entered.
For example, if I enter 3 new records using the form, the navigation buttons at the bottom of the screen will indicate that there are 3 records available to view, however, I know that there are actually about 33 records in the data source table.
If I then close the form and return to it, it then shows 0 records available.
I hope that makes sense.
 
Have you checked its Cycle property? Is it Current Page, Current Record or All Records?
 
I've just had a look at the Cycle property, it is on All Records
 
This is because you have the forms Data Entry Property set to True. If you want to view all the records change the property to false.
 

Users who are viewing this thread

Back
Top Bottom