how to display all the records of a table onto the forms? [Archive]

View Full Version : how to display all the records of a table onto the forms?

bunty

07-11-2010, 02:51 AM

Hi..
I have created one table in access 2003.I need to display all the records of that table into the forms so I can able to perform some operation on that like add record,delete record etc.
I have tried with DCODE but its not display a data in a tabular form.Please guide me how to do that.

thanks

OBP

07-11-2010, 05:31 AM

Use the form Wizard to create a form and with the form in Design view look in the Properties "All" tab for Default View (usually 6th item down).
Set it to "Datasheet" or "Continuous Forms" mode. In Continuous Forms you have to place the labels in the form Header yourself and re-arrange the Fields under them as well.