473,671 Members | 2,384 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Change Text Field Value when dropdown option is selected

5 New Member
I am finding the way to change the text field value when we select the option from drop down list.Kindly help me out to solve this problem.
I have Departments in one dropdown list and there is other dropdown list name as "Category". When i select the department then there should be related cetagory fields in Categroy dropdown list...kindly help me out...



Thanks
Azhar
Nov 4 '13 #1
4 2728
azkhan
5 New Member
The above Query solution should be in Ms Access.

Thanks
Nov 4 '13 #2
twinnyfo
3,653 Recognized Expert Moderator Specialist
azkhan,

Please provide us some greater explanation and some sample code of what you have tried so far.

My initial thought is that on the AfterUpdate Property of the Department Dropdown box, you should requery the RowSource data for the Categories dropdown. The query underlying that drop down caneither use the data from the form's dropdown box, or you could set a global variable that is updated after the Departments dropdown and use that global variable in the query.

There are mulptiple options, but we don't know what your tables, dropdowns and variables look like, so I can't get any more specific.

Grace and Peace,
Twinnyfo
Nov 4 '13 #3
zmbd
5,501 Recognized Expert Moderator Expert
The following deal with filtering within forms; however, the ones you should take a very careful look at are Cascaded Form Filtering and Multiple Combobox Filter with Clear Option as these two should point you in the direction I think you're heading in...

I know that these can be heavy reading, please do the best you can and if you get stuck please post the question back here and we'll do our best to get you going again d(^-^)b
-z

-filtering-
Nov 6 '13 #4
azkhan
5 New Member
Thanks for Reply.I will follow the instructions that you have mentioned above and inform you about its updates.

Thanks
Nov 7 '13 #5

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

Similar topics

2
3784
by: gabon | last post by:
I'm creating a select entirely through JavaScript and very strangely IE doesn't show the text in the option elements. Here part of the code: this.form_country=document.createElement("select"); var option; for(var i=0; i<arr.length; i++){ option=document.createElement("option"); option.value=arr.code;
1
8005
by: Mark Noten | last post by:
This following HTML page works fine in Firefox 1.5 but not in IE6. Help is appreciated. <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta http-equiv="content-type" content="text/html; charset=ISO-8859-1"> <meta http-equiv="content-script-type" content="text/javascript"> <title>Just a test</title>
4
6135
by: sid derra | last post by:
hi i am trying to change the value of a text field on my page dynamically, every time an iframe loads. #========== the code where the text field is looks like this: <form name="test_form">
2
1557
by: dharmadam_man | last post by:
I want to use MERGE to UPDATE the rows when there is a match. If there is no match, I want to INSERT the rows, and at the same time change a column value to a constant. For example, change the PURGE_INDICATOR to 'Y' to all inserted rows. Is there an elegant way to achieve this?
3
4310
by: dugald.morrow | last post by:
I have some javascript that updates the text in a text field after certain actions take place such as clicking a checkbox. The javascript works fine in Safari and Firefox, but in IE, the text in the text field remains empty. The page containing this problem is at the following location: http://www.skicow.com/component/option,com_skicow/act,shop/Itemid,51/debug_enabled,true The last parameter enables debug which results in alerts...
4
2729
by: Shinee Nag | last post by:
What I am trying to do is add first text field right after a dropdown menu only if the user selects a first option, when a user selects second option then second text field is opened I am new to java script so pls help me.....
2
17262
by: MOzgaf | last post by:
Hi, The problem is I have a list that i want to send to other file(php) but I want to send two corresponding variables. I was wondering if this is easy with the hidden field. <select id='myselect'> <option value='1'>A</option> <option value='2'>B</option> <option value='3'>C</option> <option value='4'>D</option> </select>
3
2123
by: rameshbabu1251 | last post by:
hi i am getting trouble in displaying text field value as web page title on entering text in text field. can any one help me solving this problem here my code <html> <head> <script type="text/javascript"> function showtitle(tl)
1
2467
by: Avinash Gupta | last post by:
hello, i want to insert a text field value into access data base file. but there is a problem that i have a single text field of month and in database there is 12 coloms of monts(january,febuary,march...) if i select a june in text field. then data should be entered in june colom. please send the java code for this.
0
8400
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
8924
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8823
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 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...
0
8672
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
5702
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
4227
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...
1
2817
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
2058
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1814
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.