Problem populating a list box from a table

[dogdays]

win 7 32 bit, access 2003
I have a list box (lsbauthors) which I am trying to populate using a temorary table. The table has one column (tName). I have set the list box control source to tName and the row source to the table. I first delete all the table entries and then insert appropriate data. The temporary table contains 1267 rows, the data is valid. The list box shows 501 rows containing #Deleted followed by the actual data. Suggestions appreciated.

Jack

 

[Norie]

Jack

How and when are you creating the temporary table?

Is it not possible to use a query instead of a temporary table?

 

[boblarson]

If you have to use the temp table, make sure you requery the combo box in the On Load event of the form.

 

[dogdays]

Norie:
Using SQL I selected distinct author names from a table. Using the resultant recordset I simply INSERT into the temp table The data in the temp table is valid. Prior to doing the INSERTs I did DELETE * FROM tblName. I will look into using a query.

Bob:
The list box is only populated when the user presses a command button. The list box is used to filter by author names. I think I do not need to requery.

Jack

 

[Norie]

JAck

Is there any need for the temporary table?

Why not use the SQL of the select distinct query as the row source of the listbox?

 

[dogdays]

Norie:
Per you suggestion I used a query, it now works. Thank you.

Jack