473,320 Members | 1,691 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Listbox Selection

173 100+
Hi,

how can i populate some empty fields/comboboxes by clicking a record in the listbox?

the fields come below the listbox, possibly a subform............

the details are stored in my table..................??
Dec 20 '06 #1
10 1719
Beany
173 100+
?? any1 :) help would be appreciated... im a bit stuck !!!
Dec 21 '06 #2
MMcCarthy
14,534 Expert Mod 8TB
Hi,

how can i populate some empty fields/comboboxes by clicking a record in the listbox?

the fields come below the listbox, possibly a subform............

the details are stored in my table..................??
Beany you will need to give a lot more information. What is the record source of the form? What is the Row Source of the Listbox? What records to you want to show in the subform?

Mary
Dec 21 '06 #3
Beany
173 100+
Beany you will need to give a lot more information. What is the record source of the form? What is the Row Source of the Listbox? What records to you want to show in the subform?

Mary

Hi sorry about that,

the record source of my form is Query1............

the row source of my listbox is Query1...................

The listbox contains fields such as provider, product,address,postcode,ip,tel etc etc. The only ones i hav made viewable is PROVIDER, TEL, POSTCODE AND SITE.

So if i click on the listbox list, i just want it to show all the details just below it.......


my table is called tab_data..................

does that make sense?
Dec 21 '06 #4
MMcCarthy
14,534 Expert Mod 8TB
Sorry Beany I still need more information

Can you post the full SQL for Query1

The listbox contains fields such as provider, product,address,postcode,ip,tel etc etc. The only ones i hav made viewable is PROVIDER, TEL, POSTCODE AND SITE.
I don't understand what you mean here

Mary
Dec 21 '06 #5
Beany
173 100+
Sorry Beany I still need more information

Can you post the full SQL for Query1



I don't understand what you mean here

Mary
Ok the SQL for Query1 is:

Expand|Select|Wrap|Line Numbers
  1. SELECT tab_data.provider, tab_data.product, tab_data.site, tab_data.tel, tab_data.address_1, tab_data.address_2, tab_data.address_3, tab_data.postcode, tab_data.ip, tab_data.username, tab_data.password, tab_data.use, tab_data.type, tab_data.status, tab_data.notes, tab_data.line_provider, tab_data.line_status
  2. FROM tab_data
  3. WHERE (((tab_data.provider) Like "*" & [Forms]![Search]![Search2] & "*")) OR (((tab_data.site) Like "*" & [Forms]![Search]![Search2] & "*"))
  4. ORDER BY tab_data.provider;
Dec 21 '06 #6
MMcCarthy
14,534 Expert Mod 8TB
Ok the SQL for Query1 is:

Expand|Select|Wrap|Line Numbers
  1. SELECT tab_data.provider, tab_data.product, tab_data.site, tab_data.tel, tab_data.address_1, tab_data.address_2, tab_data.address_3, tab_data.postcode, tab_data.ip, tab_data.username, tab_data.password, tab_data.use, tab_data.type, tab_data.status, tab_data.notes, tab_data.line_provider, tab_data.line_status
  2. FROM tab_data
  3. WHERE (((tab_data.provider) Like "*" & [Forms]![Search]![Search2] & "*")) OR (((tab_data.site) Like "*" & [Forms]![Search]![Search2] & "*"))
  4. ORDER BY tab_data.provider;
If this query returns multiple records to a listbox what will you use to uniquely identify a record from the listbox.

Mary
Dec 21 '06 #7
Beany
173 100+
If this query returns multiple records to a listbox what will you use to uniquely identify a record from the listbox.

Mary

I dont know??? im confused.............

isnt there a way where i just a click the record and it shows all the details in a form below also?

sorry im an access amateur
Dec 21 '06 #8
MMcCarthy
14,534 Expert Mod 8TB
I dont know??? im confused.............

isnt there a way where i just a click the record and it shows all the details in a form below also?

sorry im an access amateur
It has to know which record to show. You need some way to uniquely identify the record like a primary key field.

Mary
Dec 21 '06 #9
Beany
173 100+
It has to know which record to show. You need some way to uniquely identify the record like a primary key field.

Mary

ive got a userID field also in my table.....................

i didnt include it my Query1.............

shall i make that my primary key? i didnt need it to show in my Listbox?
Dec 21 '06 #10
MMcCarthy
14,534 Expert Mod 8TB
ive got a userID field also in my table.....................

i didnt include it my Query1.............

shall i make that my primary key? i didnt need it to show in my Listbox?
You don't need to show it but you do need it to identify the record you want to return.

Mary
Dec 21 '06 #11

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

Similar topics

2
by: (Pete Cresswell) | last post by:
Seems like I've been here before, but can't find anyting in Google. I've got two list boxes on a form. Seems to me like the inactive ListBox's selection rectangle should be something like...
6
by: Dan Bass | last post by:
If you look at explorer, right clicking on a file, first selects the file, then throws up the context menu relating to that selection. With a Windows ListBox control and a simple context menu,...
6
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...
6
by: Chris Leuty | last post by:
I am populating a multiselect Listbox from a dataset, with the content of the listbox filled by one table, and the selections determined from another table. So far, I have been keeping the dataset...
5
by: Lie | last post by:
Hi all, I have problem in getting selectedindex of multiple listbox selection in a datagrid. I have a listbox with multiple selection mode inside datagrid. In Edit mode, I need to get back all...
5
by: Dave H | last post by:
I have an asp:listbox, allowing multiple selections, is there a quick check to see if there's more than one selected, or do I need to go through the whole list? Thanks, Dave
0
by: Sanjin | last post by:
I have populated listbox with data from the datatable. I binded SelectedValue to the another datatable - i.e. selection result (with VS 20005 wizard). Selection result datatable has...
3
by: Kevin Walzer | last post by:
I'm trying to set the active item in a Tkinter listbox to my application's currently-defined default font. Here's how I get the fonts loaded into the listbox: ...
9
by: zdrakec | last post by:
Hello all: Clearly, I'm not getting it! Here is the scenario: On a web page, I have two list boxen and a text box. The first listbox is populated at page load time (if it is not a postback)....
4
by: kimiraikkonen | last post by:
Hi, I have a odd but a known question about listbox. I know listbox control can provide multi-select, multi-extendend selections. But i wonder if this selection type belongs to them or it has...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.