Creating a Multi-Select list box and updating subform

[Invader89]

Hi,

I currently have form called 'form' that has 2 combo boxes ('Search by Player name' and 'Search by Player group') and 2 subforms that return different results based on selection you make.

 

[Invader89]

Is there anyone who can help me with this?

 

[pbaldy]

You could use this to open another form:

http://www.baldyweb.com/multiselect.htm

It could be adapted to filter a subform (it basically builds the filter).

 

[Invader89]

You could use this to open another form:

http://www.baldyweb.com/multiselect.htm

It could be adapted to filter a subform (it basically builds the filter).

what would need to change in the code to reference the subform?

thanks

 

[pbaldy]

Along the lines of:

Me.SearchbySupp.Form.RecordSource = "SELECT * FROM TableName WHERE EmpID IN(" & strWhere & ")"

 

[arnelgp]

is it possible for you to upload your db sir?