When the form is displayed, the list box will be empty, but when the "Populate the List Box" button is clicked, the list box will be filled with the names of the shippers with their telephone numbers in the database, as shown. Before the list box is filled, the message box will appear with the value list. The value list produced by the above program is shown in the message box in this picture.
For the purposes of this display, the form's record navigator, separator and record related properties have been set to false.
This tutorial is about binding data from the underlying database to the otherwise unbound controls from the toolbox in Microsoft Access. The Recordset property of the MS Access form provides a solid link. What is covered in this tutorial is only part of the story. It has provided only the basic building blocks for code based application development. For application development related questions, please pose your questions to the article blogs.
| DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware. |