Modifying The Row Source Of A List Box On A Data Access Page In Access

When you add a drop-down list box or list box to a data access page by using a wizard, Access sets the ListRowSource property of the drop-down list box or list box to the table or query you selected as the control's data source. A ListRowSource is the name of a record set in the data source that supplies the values and text for the control. When the data access page is created and saved, the SQL statement behind the ListRowSource is saved with the page (in an .htm file) as static text. This paper explains the ways of Modifying the row source of a list box on a data access page in Access.