VB code for multiple filter in form?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cam - 14 Feb 2008 22:41 GMT

Hello,

I have a form with a unbound field to input to filter out the data, what do
I put in the code to filter two unbound fields instead of one? Other unbound
field is named SelectSide. Thanks
Here is my current code.

Private Sub SelectItem_AfterUpdate()

' Find the record that matches the control.
DoCmd.ApplyFilter , "tbl_Item = Forms!frm_MCHMC_Expect_Edit!SelectItem"
EnableControls Me, acDetail, True
Me!tbl_MCID.Enabled = False
Me!SelectItem.SetFocus
Me!SelectItem.Requery

End Sub

Reply to this Message

Allen Browne - 15 Feb 2008 01:50 GMT

Cam, take a look at this example:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

There's a downloadable example for you to pull apart. It illustrates how to
create a filter based on any combination criteria the user chooses, even
fields of different types, or ranges of dates.

Signature

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.

> Hello,
>
[quoted text clipped - 15 lines]
>
> End Sub

Reply to this Message