[AccessD] Finders problem

I use a saved query for the row source of a drop down or list box.  Then in the criteria of the query I use a like statement for some control on the form.  After the control has been changed, I do a refresh of the form.  
This works using groups, drop downs, lists or just a radial button.  I also use a double-click to clear the first control and reset the drop down or list box to show all records.
I stay away from the ApplyFilter command.  In my experience it doesn't work as well.

Jim 
jhewson at nciinc.com 
  

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Wednesday, July 16, 2008 9:03 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Finders problem

Thanks Asger. Will try that right now.

A.

On Wed, Jul 16, 2008 at 9:07 PM, Asger Blond <ab-mi at post3.tele.dk> wrote:

> Arthur,
>
> 1. Have the rowsource for your dropdown select all the columns of the
> form's
> recordsource (eventually set column width to 0 for columns not to be
> displayed).
> 2. On the form's ApplyFilter event:
>
> Private Sub Form_ApplyFilter(Cancel As Integer, ApplyType As Integer)
>        If Me.Filter <> "" Then
>                cboFinders.RowSource = "SELECT * FROM " & _
>                        Me.RecordSource & " WHERE " & Me.Filter
>        Else
>                cboFinders.RowSource = Me.RecordSource
>        End If
> End Sub
>
> HTH
> Asger
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
################################################################################

This email transmission contains information from NCI Information Systems, Inc. 
that may be considered privileged or confidential and is intended solely for the 
named recipient.  If you have received this message in error, please contact the 
sender immediately and be aware that the use, copying or dissemination of this 
information is prohibited.

################################################################################