Access Form with combo/list/sub How to Requery?

[befine]

I have a form with a combo box, list box and a subform.
The combo box has a list of companys. After update populates the list box with contact names; first,last, phone from the contact table.
What I’m trying to do is: When I click on a name in the list box, I want to populate the subform with all the info from the contact table. I’m using the on_click event of the list box, but I can’t figure out how to change/update/requery the subform or even how to refer to it. I’d appreciate it if some one could lead me in the right direction.

Thanks
befine

 

[dumdum]

Here is how you would refer to the subform... You need to refer to the forms "form" property.

Forms![Orders]![Orders Subform].Form We are always looking for new members at our computer forums:

http://forums.jlrforum.net

 

[befine]

Thank you. It's exactly what I needed.