Solved

Get a list onto my form,   with search capabilities.

Posted on 2014-02-11
3
344 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 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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

749 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