Change Text Field Value when dropdown option is selected

[azkhan]

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

[azkhan]

The above Query solution should be in Ms Access.

Thanks

[twinnyfo]

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

[zmbd]

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-

• Microsoft Access / VBA Insights Sitemap
• How to select Records in an Access Subform from a Combo Box
  
• Cascaded Form Filtering
• Multiple Combobox Filter with Clear Option
• Example Filtering on a Form.

[azkhan]

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

Thanks