Solved Problem with List Box

[Addie]

Hi Everyone,


I am facing an issuw 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.

 

[motleyjew]

Quick guess. I think you just need to requery your listbox upon entry.
me.listbox.requery

Gregg

 

[Addie]

Hi Gregg,

Thanks for the answer but this should be written before listbox.display = true ?

Regards,
Addie

 

[motleyjew]

I'm not familiar with the .display command. I rarely use listboxes. I just remember the last time I used one, it was based off of a combo box. After i ran the code on the after update on the combo box, I used the requery command at the end and the proper items appeared on the listbox. Sorry I don't have a better answer. Mayber someone more experienced can help out with that.

Gregg

 

[Addie]

Hey Thanks Gregg , It worked.

Regards,
Addie.