program combo box to retrieve data

[mike]

Hi All,

How can I program the combo box to automatically retrieve
the data when the form starts. I created a main form and
this main form contains a subform. In the subform, I have
a combo box. This combox will check the userID and
userName in the main form and from there, it will do a
query and display the data base on the userID and user
name. How do you program the combo box to do this??

For example:

Main form
userID:
username:

Subform within the main form
combo box
(This combo box takes the userID and username from the
main form and do a query)


Thnaks for the help...

mike

 

[mike]

Please Ignore this post. The issue have been solve.

Thanks,

mike