Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old January 27th, 2005, 07:28 PM
Authorized User
Join Date: Dec 2004
Posts: 48
Thanks: 0
Thanked 0 Times in 0 Posts
Default Re: need a correct method to set filter

Hi, there:
   I am back to this forums. Thank you for all the replies! I used the code from Bob and made some modifications.
   Now I need some hints from here to solve my problems. I have a dialog named "menu" consisting two items: client name(combo box); status(check box). If I select a client name and the check box is checked, then click open button, I should see a specific client whose orders were closed in a form(named"ordres). Else If I don't select client name and check box is checked, I will see all the open oreder for all clients; else(don't select client name and leave the check box unchecked), I would see all the records.
   I tried several ways to set criteria to the record source under the form, but fail!:(

Old January 27th, 2005, 07:36 PM
Friend of Wrox
Join Date: May 2004
Posts: 642
Thanks: 0
Thanked 43 Times in 42 Posts

Can you paste the code which you tried and getting error?

Om Prakash
Old January 28th, 2005, 06:32 AM
Authorized User
Join Date: Dec 2004
Posts: 48
Thanks: 0
Thanked 0 Times in 0 Posts

Hi there,
 I use a dialog "menu" to collect search criteria.

 The "menu" dialog includes:
 client(combo box)
 Open_order(check box)
 Private Sub submit_Click()
   DoCmd.OpenForm "order"
 End Sub
  (I am wondering how can I set criteria here and parse it to the "order" form)

 After the user click "submit" button in the "menu", a form named "order" should display all records which satisfy with the criteria.

 In the "order" form, I had a query

 My questions are as follows:
 If user doesn't select anything from the combo box(I should see all the clients in the "order" form).
  If the open_order isn't checked, I would see all the open orders in the "order" form.
  I don't know how can I set these criteria correctly in the query under the "order" form?


Similar Threads
Thread Thread Starter Forum Replies Last Post
XPath: set operation with a disjoint node set rich_unger XSLT 7 May 6th, 2008 09:24 AM
Is it correct like this ? tunisiano C# 1 March 7th, 2007 12:22 PM
Invoice Set & Get Method wldctj8 Java Basics 2 October 13th, 2006 09:50 PM
How to set a session in Java Filter? Edward King Pro JSP 1 January 31st, 2006 05:34 AM
Javascript SET Method? TSEROOGY Javascript How-To 2 February 7th, 2004 09:20 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.