• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

Creating a Multi-Select list box and updating subform (1 Viewer)

Invader89

Registered User.
Local time
Yesterday, 20:46
Joined
Sep 22, 2015
Messages
29
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.
 
Last edited:

pbaldy

Wino Moderator
Staff member
Local time
Yesterday, 17:46
Joined
Aug 30, 2003
Messages
34,626
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).
 

pbaldy

Wino Moderator
Staff member
Local time
Yesterday, 17:46
Joined
Aug 30, 2003
Messages
34,626
Along the lines of:

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

arnelgp

error reading drive A:
Local time
Today, 08:46
Joined
May 7, 2009
Messages
10,575
is it possible for you to upload your db sir?
 

Users who are viewing this thread

Top Bottom