Prev: Help screen for VBA in A2007
Next: undo sorts button
From: Kaliman on 11 May 2010 00:42
I have Allen's Browne Search 2000 form in My Database in Access 2000. The
search controls are in Form Header and I would like that after clicking the
filter button, records must be displayed in another Form (in my case FData)
rather that in Detail. Could you suggest how to do it. I would really
appreciated it if you show me how to do it step by step since I am novice in
programming.



Thank you
From: Allen Browne on 11 May 2010 03:18
Presumably we are talking about the code in from example:
http://allenbrowne.com/ser-62.html

The Click event procedure for the command button builds up a filter string,
and then applies it to this form with:
Me.Filter = strWhere
Me.FilterOn = True
If you have FData already open, you could apply it to that form instead by
substituting:
Forms!FData.Filter = strWhere
Forms!FData.FilterOn = True

If you don't have it open already, use:
DoCmd.OpenForm "FData", WhereCondition:=strWhere

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"Kaliman" <Kaliman(a)discussions.microsoft.com> wrote in message
news:69DE3885-2C0F-468B-8C83-B21357684CCC(a)microsoft.com...
> I have Allen's Browne Search 2000 form in My Database in Access 2000. The
> search controls are in Form Header and I would like that after clicking
> the
> filter button, records must be displayed in another Form (in my case
> FData)
> rather that in Detail. Could you suggest how to do it. I would really
> appreciated it if you show me how to do it step by step since I am novice
> in programming.
>
>
>
> Thank you

 | 
Pages: 1
Prev: Help screen for VBA in A2007
Next: undo sorts button