Method 1Ĭreate a table named Products that has the ProductID field and the ProductName field. These methods can also apply to text boxes. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. Microsoft provides programming examples for illustration only, without warranty either expressed or implied. These four methods are outlined in the "More Information" section of this article and are based on the Northwind sample database. Base the form on a query that joins two tables, and then use the AutoLookup technique to bind a combo box to the field that controls the join.Use a Form/Subform, with a combo box on the main form, and the data in the subform, bound by the LinkMasterFields and LinkChildFields properties of the subform control.In the AfterUpdate event of a combo box, call a macro that requeries the Filter property of a form.In the AfterUpdate event of a combo box, execute code that uses the FindFirst method.This article shows you four methods of moving to a specific record based on selection from a combo box. This article applies to a Microsoft Access database (.mdb) file or to a Microsoft Access database (.accdb) file. Moderate: Requires basic macro, coding, and interoperability skills.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |