Dynamically populating Access (ADP) List Box
Posted on 2007-07-23
I have a access (ADP) form which has (1) a combo box, "Table_Name", from which a user can select the name of a database table and (2) a List Box, "Table_Entries", which displays the contents of that table. To populate "Table_Entries", I have the following code:
Private Sub Table_Name_Change()
Me.Table_Entries.RowSource = "select * from " & [Table_Name]
However, this code does nothing. "Table_Entries" remains blank and if I look at the value of "RowSource" under design view, its value is unchanged. However, if I manually edit the value of "RowSource" under design view, "Table_Entries" is correctly populated.
OS: MS XP Version 2002, 5.1.2600 Service Pack 2 Build 2600
Access: Access 2003 (11.6566.8122) SP2
Database: Microsoft SQL Server 2005
Anyone have a clue whats going on?