Display Query in listbox from combobox

Seth Delaney

I have a form with a combobox and a list box. The combobox will list
records (names of queries) that are entered in a table called
tblListName. I have the combobox set to get its values from this
table. tblListName has two fields: ListName and QueryName where
QueryName is the actual name of the query and ListName is a "friendly
name" to be displayed. No problem, I'm good so far.

However, I have trouble here: I want the listbox to list records (same
fields for each query) from the query that was selected in the
combobox.

Any help is appreciated... I've done an exhaustive search on this
group and have yet to find the solution.

Thanks

Nov 13 '05 #1

Subscribe Reply

2623

PC Datasheet

This will only work if the order of the fields in all the queries is such
that the bound column you want in the listbox is in the same field position
in all the queries and the field you want to display in the listbox is in
the same field position in all the queries. If not, you need to store this
information in your table of queries also.

Assuming the above conditions are met, all you need do is make sure the name
of the query is the bound column in your combobox and then in the
AfterUpdate event of the combobox, put this code:
Me!NameOfListbo x.Rowsource = Me!NameOfCombob ox
Me!NameOfListbo x.Requery

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.com
www.pcdatasheet.com
"Seth Delaney" <sa******@excit e.com> wrote in message
news:27******** *************** **@posting.goog le.com...

I have a form with a combobox and a list box. The combobox will list
records (names of queries) that are entered in a table called
tblListName. I have the combobox set to get its values from this
table. tblListName has two fields: ListName and QueryName where
QueryName is the actual name of the query and ListName is a "friendly
name" to be displayed. No problem, I'm good so far.

However, I have trouble here: I want the listbox to list records (same
fields for each query) from the query that was selected in the
combobox.

Any help is appreciated... I've done an exhaustive search on this
group and have yet to find the solution.

Thanks

Nov 13 '05 #2

Similar topics

2492

Listbox Positioning

by: Mike Top | last post by:

I want a listbox to position to a letter provided by the user. Normally, when the user keys a letter, the listbox positions automatically to the first entry starting with that letter in the first column. I want to allow the user to select the column to be searched. For eaxample, assume a list box that looks like this: ____________________________

Microsoft Access / VBA

1703

Re-use report by using a query to filter

by: seansan | last post by:

Hi, suppose I have one report that reports some data to me based on a functional area that I define. We have about 20 func_areas and every time the report is the same. Is there some way to have the report ask me (based on a query or something) what func_area I would like the report to be based on? ps. the report is based on a query so ultimately the selection has to be passed to the query.

Microsoft Access / VBA

1998

How do I pass the value from a list box into a query?

by: Andrew | last post by:

I've got two tables in my DB, a Client table and an Event table. There are many events for each client. The form I designed is based off of the Client table and the subform within it is sourced from the Event table. The way things are currently designed places a list of clients on the left side of the form (with a list box), and then there's a subform on the right side of the main form with fields to enter event information.

Microsoft Access / VBA

2618

Global variables are slowing down the query

by: Jean | last post by:

Hello, I have the following query that I set up as a test, and it runs fine: SELECT STATUSHISTORIE.* FROM STATUSHISTORIE LEFT JOIN PROBLEM_DE ON STATUSHISTORIE.PROBLEM_ID = PROBLEM_DE.PROBLEMNR WHERE (((STATUSHISTORIE.STATUSDATUM)<#1/1/2005#) AND ((PROBLEM_DE.DATENBEREICH)='SPMO') AND (((Left((.),InStr(.,"-")-2)))='K29')

Microsoft Access / VBA

4026

Using combo-box as a user filter - trying to use format to display text "all" for null values

by: google | last post by:

This is something I've done plenty of times in '97, but I can't seem to get it to work correctly in Access 2003. Say, for example, I have a form with an unbound combobox, the data source is a table of customers, first column is the key field, which is hidden with a 0" width, and the second column is the customer name. The SQL is a union query that also inserts Null in the first column, and "All" in the second column. That combobox gets...

Microsoft Access / VBA

1315

display one string and store another in same combobox item

by: VMI | last post by:

Is it possible to display something in a combobox and store something else? For example, can I display "Query for active employees" and save the actual query in the same combobox item? That way I can automatically retrieve the specific query for the option the user chose. Is this possible? Thanks.

C# / C Sharp

12900

How to refesh a listbox bind to a dataview?

by: Alpha | last post by:

I have a listbox with datasource from a dataview. When a user selects a different item in a combobox then I need to refresh the listbox to the appropriate listing based on that combobox's selected value which is included in the listbox's filtering statement. Is the only way to do this is to dispose the dataview and then create a new one and then bind it to the listbox? Is there a better way than this? Thanks, Alpha

C# / C Sharp

2752

Can't change focus for listbox VB.NET 2005

by: Crazy Cat | last post by:

Hi, I have a form with a databound listbox and combobox. The listbox items are filtered based on the selection for the combobox. If I click on the listbox to select an item, I can no longer select the combobox or even exit the form. It's as if something won't let me take focus away from the listbox -- all I'm able to do is navigate within the listbox.. There is no error or exception thrown -- I just can't access anything outside of...

Visual Basic .NET

1526

ComboBox Query question

by: JonnyRotten | last post by:

I have two tables The first has a ID (key) field and enteries for Name The second has a ID field (tied to the first) and then 6 fields for activities. Called Activity1, Activity2, etc etc I would like to make a form that when they selected their Name from a combo box, another combobox would take its selections from a query tied to their name and put their 6 Activities into the second combo box. Writing the query is no problem, I just...

Microsoft Access / VBA

8413

What is ONU?

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...

General

8740

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8513

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8617

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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...

General

7352

AI Job Threat for Devs

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...

Career Advice

5642

Couldn’t get equations in html when convert word .docx file to html file in C#.

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();...

C# / C Sharp

4173

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4330

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2742

transfer the data from one system to another through ip address

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

C# / C Sharp