Binding Data to Controls with MS Access and ADO - Retrieving and displaying data using text boxes

(Page 2 of 6 )

This way of displaying data has been around since the days of DAO. A number of text boxes bound to the various columns of the table, or fields returned by a query, are displayed in the text boxes as the recordset is moved in either direction. The minimum that is required for this is a CursorType that will support this bi-directional data movement. For this tutorial the text boxes will display the three columns returned by the select statement shown here.

Select * from Shippers

Place three text boxes on the form that will serve as the canvas for the different controls that will be placed on them. The picture shows the three text boxes, and the picture that follows it shows the properties of the form which can be accessed by right clicking on the black square dot at the top, left end of the form in the design view shown in this picture.

The record source property of the form is empty, and the three text boxes are unbound.

Next: Code to retrieve the recordset >>
 

More ASP.NET Articles
More By Jayaram Krishnaswamy

Comments On: Binding Data to Controls with MS Access and ADO

· The predominance of Microsoft products, especially its Office is primarily because...    · Very good explanation.I couldnt get mine to work for a while, but then I took...   >>> Post your comment now!