cbo value based on another cbo value. 3 Steps

Shafique

New Member
Joined
Nov 23, 2018
Messages
27
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

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

JonXL

Active Member
Joined
Feb 5, 2018
Messages
326
Office Version
365, 2016
Platform
Windows
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.
 

Shafique

New Member
Joined
Nov 23, 2018
Messages
27
Right,
But there is a lot of work to do again. So please find any solution with current DB Setting
 

welshgasman

Well-known Member
Joined
May 25, 2013
Messages
777
Bring all the values in to your first combo, and then assign your next control value from one of the combo source columns.
 

Shafique

New Member
Joined
Nov 23, 2018
Messages
27
Bring all the values in to your first combo, and then assign your next control value from one of the combo source columns.




Sir,
I am new in Access. So Please Help Me With Sample File Or Video.


THANKS
 

xenou

MrExcel MVP, Moderator
Joined
Mar 2, 2007
Messages
16,628
Office Version
2013
Platform
Windows
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).

 

Watch MrExcel Video

Forum statistics

Threads
1,095,728
Messages
5,446,174
Members
405,389
Latest member
Excel n00b2

This Week's Hot Topics

Top