cbo value based on another cbo value. 3 Steps

Shafique

Board Regular
Joined
Nov 23, 2018
Messages
117
Hi Everyone.
I am working on a INVENTORY Database.
in my database i define one Item in 3 step.
e.g Item Name Item Type Item Size
Cable 2 Core 7/29
Bearing ball 6203
Bearing ball 6306

I stored these information in same table.
Here i want that when i post a item in or out entry i select Item Name (e.g: Bearing) The very next filed automatically update with its Item Type (Ball) and as on Item Size (6203, 6306)
 

Attachments

  • Untitled.png
    Untitled.png
    23 KB · Views: 12

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
It sounds like you have a design problem with your DB.

Instead of putting every item and its possible sizes in the same table, these should go in separate tables related to one another by their primary keys.

Then to add items and their different sizes, you first enter the item and then add as many sizes you want under that entry, which is accomplished through subforms without the need to enter or repeat all the basic descriptors of the item for every different size you want listed in your DB.
 
Upvote 0
Right,
But there is a lot of work to do again. So please find any solution with current DB Setting
 
Upvote 0
Bring all the values in to your first combo, and then assign your next control value from one of the combo source columns.
 
Upvote 0
It looks like you are looking for "Cascading Combo Boxes" also known as "Dependent Combo Boxes". Unfortunately if you are new to Access this is an advanced topic and you might find it difficult. Here are some links and also try googling for the above keywords (along with MSAccess to limit the search to results related to microsoft access - there are probably youtube videos to watch as well).

 
Upvote 0

Forum statistics

Threads
1,213,567
Messages
6,114,344
Members
448,570
Latest member
rik81h

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top