Hello, I have a problem with Access that I hope someone can help with.

I have a main form entitled "Main", which contains a sub form entitled "DataSheet", this is a datasheet representation of a table in the database. Within the main form, there is a combo box and when the user selects an item from here I need to update the sub form so that it queries the data on this value. Is there any easy way to do it?

Thanks

Andrew