Is there a limit to the number of fields that a subform can link to a main form? I have having issues with linking 5 different fields on a subform where all 5 fields are in the main form and hidden in the subform (all 5 fields are in both tables).
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…