In the code bank (Page 7 or 8), there's some techniques I use. You may also want to look at all the different kinds of search forms posted as examples.
Typically, I'll make a subform so that it has criteria in the recordsource (ie. under the ClientName field) as such: Like Forms!MyMainFormName!MySearchComboboxName & *
Then, on the Main form in the AfterUpdate event of the MySearchComboboxName combobox, I'll simply add a: me.MySubformName.requery
I'd highly recommend avoiding using any .Filter type commands. The .Filter doesn't work reliably from my experience.
To store the ClientName (from an unbound combobox to the subform), use a command such as: Forms!MyMainFormName!MySubFormName!ClientName = Forms!MyMainFormName!MyUnboundComboboxName (note it's sometimes best to make a reference to the control directly versus me.mySubFormName.ClientName.value.)
Last edited by pkstormy; 02-04-10 at 09:10.
Expert Database Programming
MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)