Problem with List Box

[Addie]

Hi Everyone,


I am facing an issue while using a listbox. I am using a list box in a form to display few records based on a search criteria(After hitting search Button). These records are first stored in a table INT_TAKER (By select query and joining different tables) and in row source of list box this table name is given. But when I hit search button , records are inserted in this table INT_Taker but are not shown in list box . Second time when i hit the search button, then the inserted records are shown. I dont know why this is happeneing. After the records are inserted in INT_Taker , i coded listbox.display = true.

Please help me and tell me where I am going wrong.
Thanks.

Regards,
Addie.

 

[missinglinq]

I would guess that after inserting the records in the table the listbox needs to be re-queried.