Filtering a Form

• PaulSp

  SSCrazy

  Points: 2499

  More actions

  March 16, 2007 at 5:30 am

  #69535

  I have a form which uses a stored procedure to bring data from many different tables.  I need to filter this data in various ways, but don't want to change the RecordSource - (time factor - it takes too long to re-load). 

  I need to employ some sort of a filter which will allow SQL strings such as:

  select ID from Table1 where ID in (select person_id from vwsysuser)

  Does anybody know of a way to do this.  It seems to baulk at docmd.applyfilter.

  Maybe somebody knows a better way to 'filter' a Form's contents without changing the Recordsource?

  I'd be grateful for any help.

  Thanks

  Paul

• Perry Harts

  Ten Centuries

  Points: 1271

  More actions

  March 16, 2007 at 8:18 am

  #695484

  If you are using an ADP you can execute an SP in Access using VB to establish the parameter.

• PaulSp

  SSCrazy

  Points: 2499

  More actions

  March 16, 2007 at 10:33 am

  #695509

  Hi Perry

  Thanks for your reply.

  I am using sps with parameters.  I was looking to quickly add filter for a certain purpose.  However, you've set me off on a further line of thought...

  Many thanks again

  Paul