473,395 Members | 1,696 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,395 software developers and data experts.

2nd list appears when first list selection is made...

stonward
145 100+
Hi again. Me and my listboxes, eh?!

I have a listbox with just a small number of possible selections. When a particular one of those is selected, I want the second listbox to become visible (or similar - change recordset of original 'box, thereby using just one?etc).

I've tried all sorts of ways with no joy so far. Any takers?

Thanx in advance,

Stonward Roy.
Jul 10 '07 #1
6 1172
stonward
145 100+
Incidentally,,,with ref to my list prob - they could be combos if it helps.
Jul 10 '07 #2
Rabbit
12,516 Expert Mod 8TB
Take a look at this tutorial. It's not exactly what you're looking for but it will help you understand the properties of list and combo boxes and how to change them.
Jul 10 '07 #3
stonward
145 100+
Sorry, Rabbit...I can be a little dim I think.

I need an event to happen when one particular selection is made...can you help me with syntax for that?

Thanks for your patience!

Stonward
Jul 11 '07 #4
Rabbit
12,516 Expert Mod 8TB
Right, in that case, use:
Expand|Select|Wrap|Line Numbers
  1. If Me.ListboxName.Value = "Some String Value" Then
  2.    ...
  3. Else
  4.    ...
  5. End If
  6.  
Jul 11 '07 #5
stonward
145 100+
SOOO simple! Now I feel really dumb! That worked! Thanx Rabbit.

Stonward the Simple
Jul 12 '07 #6
Rabbit
12,516 Expert Mod 8TB
Not a problem, good luck.
Jul 12 '07 #7

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

Similar topics

3
by: LaurenW | last post by:
My company has an A2K app that has been running just fine for a long time. Recently, some users notice that the database window appears when some forms are loaded. Right before we release a...
4
by: Paul | last post by:
Hi, When should I use a list (in table properties: like Ford;Mercedes;BMW;Audi ) and when should I use a lookup table?? And second question: IF I use a lookup table, should I always make a...
5
by: kjmatthews | last post by:
I am designing a site but only have access to a Mac, equipped with Virtual PC. On IE6 is appears that, on some pages of this site, the navigation does not appear. I have put up a test case:...
12
by: joshd | last post by:
Hello, Im sorry if this question has been asked before, but I did search before posting and couldnt find an answer to my problem. I have two classes each with corresponding linked lists, list1...
2
subashini Thiyagarajan
by: subashini Thiyagarajan | last post by:
Dear friends, two list boxes are there.when i select any data from first list box second list box should automatically deactivated.how to do? i have populated list box items from database in both...
2
by: kennygee | last post by:
I am trying to learn VB after many years programming in Access. I am trying to do something in VB that is simple in Access. How do I display record data on a form based on the selection made in a...
2
by: subbaraju | last post by:
I have two selection controls and based on the selection made by the user i need to pass those values to the other program in java...... can u give me the way......
0
Krishna Ladwa
by: Krishna Ladwa | last post by:
In Sql Server 2000 Version, I found that no Notification message box appears when converting text column to varchar but the data gets truncated to the given size for the varchar. Whereas it appears...
8
by: manishamca | last post by:
i want to retrive values from backend depending on the selection made in choice box. i have two choice box and different values shuld be retrived depending on the selection made in this two...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
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,...
0
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...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
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...
0
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...
0
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...

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.