you need to understand when to drop in and out of SQL/VBA
strSQL = "SELECT NameTbl.* from NameTbl where NameTbl.[NameID]=CInt(Me.ChooseListBox.Value)"
there is no need to repeat the table name if its the same as the FROM Table or is uniquely identified within the scope of the query (ie there is only one column of that name int he current query)
strSQL = "SELECT * from NameTbl where NameID = " & CInt(Me.ChooseListBox.Value)
nor is there any need to use square brackets to delimit column or table names, if there are no spaces in your column/table names
had you actually examined the SQL you would have seen that right away.
you could have set a breakpoint/watch in the code and stepped through it examining varaiables as required
or just dumped the SQL out using a msgbox
msgbox "My SQL is:-" & strSQL
I'd rather be riding on the Tiger 800 or the Norton