473,786 Members | 2,462 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Help with Filters

21 New Member
Ok Guys,

Was hoping if you could help me. I want to create a drop down filter in Access Forms.

This names and fields are just examples.


I basically want drop down menu 1 to show the field name "city" for all the records in that table. This will filter drop down menu 2 to show all customers who are based in the city that drop down menu 1 shows. Drop down menu 2 can then open up the record as a form for that customer.

Hope that makes sense, no idea where to begin any ideas anyone?

Many Thanks!
May 20 '08 #1
5 1388
nico5038
3,080 Recognized Expert Specialist
Reading Cascading Combo/List Boxes might give you the right start.

Nic;o)
May 20 '08 #2
Marks
21 New Member
Cheers for that. I've got 2 drop down's to do filters however how do I get it to link to go to that specific record?

Cheers.
May 20 '08 #3
Marks
21 New Member
Finally got there in the end =)
May 20 '08 #4
nico5038
3,080 Recognized Expert Specialist
Well done !
For the positioning you could use the code Access generates "behind" a "Find" combobox. When defineing a new combobox, the wirzard allows with choice 3 to have a "positionin g combo" and that holds the code with the .Find and .Bookmark.

Nic;o)
May 21 '08 #5
Marks
21 New Member
I've generated this code and used a Query to help filter through 2 combo boxes.If I want to insert a "All" option which would display All in the combobox? Is there a way i can load the query which does the filtering if the dropdown value is now all or remove the query if the value is all.

Cheers.
Jun 18 '08 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

2
5845
by: Jo | last post by:
I don't know if this can be done.. But here is what i am trying to do... I have a tree menu on a frameless page. I have the menu on the right hand side and a CGI web form post on the left. When i Post a form and it displays a new html page i would like to see a different branch expaned on the tree menu and close (who be a bonus) the other one that is open.
3
1279
by: mcc | last post by:
When i put these two java scripts in the same html file only the fade script works. Why is that??? this part is in the <head>
3
1293
by: |:::. George .::::| | last post by:
Hi, When I put the first javascript, it works fine. As soon as I put the second one, the effect stops on both and you can't see any pictures. This is the script I'm using. {How can I have this effect in 3 areas of the page?}What area of the script need to be change? Thank you for your help.
1
1312
by: Jeff Smeker | last post by:
I have, over the past few years, developed a Access system that is in use in our companies engineering, purchasing, and sales departments. It is a fairly complex system that runs great. So, I am pretty well versed in Access design (many thanks to all the posters in this group too, I'm not sure I could have done without). I do have a situation that has stumped me though. I have a table listing various parts that are used for a "quote...
3
1847
by: ATS | last post by:
I'm trying to set up a slide show on a web page using Javascript. Here is the code I have so far: <script language="javascript"> alert("**in test area 1"); slides = new Array(); slides = new Image(); slides = new Image();
1
1772
by: Dieter Vanderelst | last post by:
Hello, I'm trying to access the Filters-Dll provided by the filters-project (http://filters.sourceforge.net/index.htm). Following the advice I got from the Python list -thank you for that-, I do this using ctypes (http://starship.python.net/crew/theller/ctypes/index.html). I can seem to access the image filters now provided by the Dll. But
5
2284
by: perhapscwk | last post by:
I have something like below, normally when my mouse is over the button, it will change from less visible to visible, if mouse move away, it turn back to less visible. But now i want to make it when i click the button, it will keep the status as visable even i move the mouse out from the button. Please help. Thanks. <SCRIPT> function makevisible(cur,which){ if (which==0) cur.filters.alpha.opacity=90
2
2787
by: shawnwperkins | last post by:
Hi Folks, I'm new to Javascript and just need a little help. I downloaded a script from Dynamic Drive's Web site and I'm trying to make a simple modification and could use some help. :) The script below fetches data from the web server and displays it in the form as a ticker on the web page. See: http://www.dynamicdrive.com/dynamicindex2/ajaxticker.htm What I would like to do is to have the Ajax ticker periodically go out
2
1703
by: Moiseszaragoza | last post by:
I am not sure if this goes in here ot the ASP forum I have been trying to get some simple AJAX on my site but its not going so well I am not sure what my problems is what i am trying to do is populate a text field Here is my code
1
1221
by: Berryl Hesh | last post by:
PROBLEM: I want to create a linq query of an in memory object based on 3 possible filters, and the only way I can think is something like the code below. Besides being verbose, I'm repeating myself. How can I rewrite this?? Thanks for your help - BH CODE: I've included the whole class for context, but it's the OnCriteriaChanged method at the bottom that's getting out of hand (and I haven't finished all
0
9647
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9496
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9961
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8989
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6745
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5534
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4066
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3669
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2894
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.