?
Solved

Get a list onto my form,   with search capabilities.

Posted on 2014-02-11
3
Medium Priority
?
347 Views
Last Modified: 2014-02-19
I am looking to add a list of people to my form on the lead list tab, on the contact form.  The list would be a sortable list.   It would sort by the drop down boxes and Id like to have a search box attached to the list of people too.  So the list of people would changed based on what is in the search box and what is in the drop down boxes.  

The drop downs would be like the ones on the general tab,   but I don't need the third one.  Just the first two.  and then the list of people based on the second drop down.

I need to show Policy name, connam name, connam phone, conname email, Targeting and product.  

See attached.
1.accdb
0
Comment
Question by:lehi52
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 10

Accepted Solution

by:
Gozreh earned 2000 total points
ID: 39851332
I don't know if you looking to learn, or just we should do work for you.
so to add drop downs to filter you can copy your two comboboxes, and filter the recordsource on the form with it. - I did it in the sample.

For sorting you can or use the datasheet view, or like you did with continuous form (that looks nicer) you can right click on each field and sort.
2.accdb
0
 

Author Closing Comment

by:lehi52
ID: 39851350
I really appreciate your help with this.  I will have a follow up question related to this same thing but to add to it.
0
 

Author Comment

by:lehi52
ID: 39851435
Oh, it is also nice to learn how to do it.  I will need to add something similar in regards to a list of actions on my database.  Ill take a look at your code and how you did it to see if I can apply that to the actions.  If I cant figure it out Ill ask.  Thanks again for your help.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question