listbox bound to a main form

[anniebai]

I don't know if I can explain my question clearly.
There're three tables as Scholars, Grants, ScholarWIthGrants, the relationship between scholar and grants is 'many-to-many', and ScholarWithGrants is the joint table.

A scholar form is created, as main form. a listbox as 'grantList' is embedded into this main form. The data source for grantlist is bound to the scholarID on the main form.

SELECT sg.ScholarID, sg.GrantID, sg.Title, sg.GrantRole
FROM ScholarsWithGrants as sg
WHERE sg.StudentID = [scholars].[studentID]))

when the main form is on load, the grantlist displays the correct list for the first scholar. while using the navigation button at the bottom of the main form, the scholarID is moving on, but grantlist stays unchanged. don't know what event is with navigation button.

I understand I may use subform instead of listbox, and subform worked fine. But there're other purposes of using listbox, e.g. click on one listed records and others.

Please help... What shall I do for such a situation?
Thanks for any suggestions and helps........

[FishVal]

I don't know if I can explain my question clearly.
There're three tables as Scholars, Grants, ScholarWIthGrants, the relationship between scholar and grants is 'many-to-many', and ScholarWithGrants is the joint table.

A scholar form is created, as main form. a listbox as 'grantList' is embedded into this main form. The data source for grantlist is bound to the scholarID on the main form.

SELECT sg.ScholarID, sg.GrantID, sg.Title, sg.GrantRole
FROM ScholarsWithGrants as sg
WHERE sg.StudentID = [scholars].[studentID]))

when the main form is on load, the grantlist displays the correct list for the first scholar. while using the navigation button at the bottom of the main form, the scholarID is moving on, but grantlist stays unchanged. don't know what event is with navigation button.

I understand I may use subform instead of listbox, and subform worked fine. But there're other purposes of using listbox, e.g. click on one listed records and others.

Please help... What shall I do for such a situation?
Thanks for any suggestions and helps........

Hi!

When you browse through the records, each time a record has been populated form Current event is triggered. Here you can populate your Listbox with a relevant records.

[anniebai]

Hi!

When you browse through the records, each time a record has been populated form Current event is triggered. Here you can populate your Listbox with a relevant records.

Thanks a million.
It worked at the first try.