listbox requery on subform with no previous data

[Guest]

I need to requery an unbound listbox on a subform from a third form's close
event. The simple requery method works if the listbox already has data, but
it does not work if the listbox was blank before the third form was opened.

I tried the requery method:
Forms![frm_task_detail]![frm_view_notes].Form![lst_notes].Requery

And also setting the rowsource of the listbox:
Forms!frm_task_detail!frm_view_notes.Form!lst_notes.RowSource = "SELECT
tbl_notes.Notes_ID, tbl_notes.Username, tbl_notes.Date, tbl_notes.Notes FROM
tbl_notes WHERE (((tbl_notes.Task_ID)=Forms!frm_task_detail!Task_ID)) ORDER
BY tbl_notes.DateEntered "

Neither bits of code seem to work. Any help is always greatly appreciated.

Thanks,
Melanie

 

[Guest]

I'm still having trouble with this. Does anyone have any ideas? Thanks.