Hi Aximboy,
My apologies for not getting back to you sooner, but have been on holiday.
Basically, the example I've given works the same for both continuous forms and datasheet views.
Note that I have 3 combos, cmbAuthor, cmbTitle and cmbPublisher. I also have 3 hidden unbound text boxes corresponding to the combos, txtAuthor, txtTitle and txtPublisher. The default values of these text boxes are "*".
The query "qry_Find/Filter" which the FindExampleSubForm is bound to uses the hidden unbound text boxes as it's criteria.
When the user makes a selection from any of the combos the corresponding text box is updated with that selection, the other combos and the sub form are requeried.
If you look at the code in the After Update event of each combo in the FindExample form and the On DblClick event of txtAuthor in the FindExampleSubForm form you should get a good idea of what is going on and be able to adapt your own DB to this method.
I strongly advise to use VBA code to build your applications, not macros as you have intimated above.
If you have any further questions, don't hesitate to ask.
Bill