By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,827 Members | 2,220 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,827 IT Pros & Developers. It's quick & easy.

Change Text Field Value when dropdown option is selected

P: 5
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...

Nov 4 '13 #1
Share this Question
Share on Google+
4 Replies

P: 5
The above Query solution should be in Ms Access.

Nov 4 '13 #2

Expert Mod 2.5K+
P: 3,283

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,
Nov 4 '13 #3

Expert Mod 5K+
P: 5,397
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

Nov 6 '13 #4

P: 5
Thanks for Reply.I will follow the instructions that you have mentioned above and inform you about its updates.

Nov 7 '13 #5

Post your reply

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