[AccessD] filtering a subform

Something like this.... You would of course need to build the
strSearchString criteria

Dim strSearchString		As String

With me.ctrSubform.Form
.Filter = strSearchString
.FilterOn = True
End with 


Robert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Wednesday, September 21, 2005 4:45 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] filtering a subform

I'm trying to use an option group to filter a subform -- easy enough as
long as there's some relationship between the options and the subform. 
 
If there's no relationship and you don't want to use the subform's
linking properties, how do you set the filter the subform's Record
Source? The subform is based on a query. 
 
Susan Harkins
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com