Results 1 to 2 of 2
  1. #1
    bigmac is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2008
    Posts
    21

    Question open form based on comboboxes


    hi all, i havd two forms "findclient" and "form1" on "findclient" there are two comboboxes,[client_name" and "job" also a button to open form1, when i select a client it then filters what is shown i the "job"combo, this is working fine but now i want the button to open form1 and show the correct filtered info on the form, can you help please?

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I'm a little confused, perhaps you could clarify. On Form FindClient , you have 2 comboboxes. One deals with "ClientName", the second with "Job". Are these Clients already assigned Jobs? Are you saying a Client could have multiple Jobs? How are the combo boxes related (cascade)?

    Typically, but not always, when you try to "Find" a record, you'd use a name or a number and do a search. It's a little different to see that you need to Search by Name and Job.

    Consider, client_name "Tobias Jones" whose job is "blacksmith", and a field in your Table called Client
    with the command to open the form with an opening argument along this line (untested)
    DoCmd.openForm "Form1",,,"Client = '" & Me.Client_Name & "'"

    If you need multiple parameters there are examples
    http://www.datawright.com.au/access_..._arguments.htm
    http://www.fmsinc.com/free/newtips/a...ccesstip13.asp

    Good luck

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 04-20-2013, 10:12 AM
  2. Open form based on query information
    By MFS in forum Programming
    Replies: 3
    Last Post: 06-11-2011, 12:44 PM
  3. Switchboard open form based on function value
    By silverspr in forum Forms
    Replies: 5
    Last Post: 03-10-2011, 02:10 PM
  4. Open form based on query results
    By RobbertH in forum Queries
    Replies: 1
    Last Post: 02-10-2010, 08:13 AM
  5. Open form based on Subform criteria
    By Suzan in forum Programming
    Replies: 0
    Last Post: 04-25-2006, 02:28 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums