Tabbed subform and listbox

[hockeyfan21]

Hi,

I have a form with 4 tabs each with a subform. They are linked to field "ID" on the main form. On the 4th tab I have a subform (Form1) and a listbox (List26) that I am filling with a query but I can't get it to change when my project (ID) # changes. I have gone into the query and tried Forms!Form1!ID and many other ways but can't get it to work.
I'm assuming I am just referring to the controls incorrectly but nothing I've looked at seems to work.

Any ideas on this one?

Thanks!

 

[Beetle]

You can't get what to work? The List box?

And what do you mean by it doesn't work? The data in the List box doesn't refresh when you change records? Do you have code to Requery the List box in the Current event of the form?

 

[hockeyfan21]

The list box wasn't populating with the data when the projectid changes on the form.

As I suspected, I was referring to the incorrect form names - tabbed forms are new to me and I got confused as to which form I need to reference in my row souce criteria filter.

Thanks for the tip on the OnCurrent.Requery too!

Toni