Solved

Get a list onto my form,   with search capabilities.

Posted on 2014-02-11
3
334 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
  • 2
3 Comments
 
LVL 10

Accepted Solution

by:
Gozreh earned 500 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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

758 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now