[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
>