cbo value based on another cbo value. 3 Steps

[Shafique]

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)

 

[JonXL]

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]

Right,
But there is a lot of work to do again. So please find any solution with current DB Setting

 

[welshgasman]

Bring all the values in to your first combo, and then assign your next control value from one of the combo source columns.

 

[Shafique]

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

 

[welshgasman]

Take your pick.

access combo box fill multiple fields - YouTube

There are plenty of videos on YouTube on using Access if you need video tutorials. Google will often supply simple code.

 

[xenou]

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).

Microsoft Access Form Cascading Combo Boxes

Creating cascading comboboxes on Microsoft Access forms so selecting one item filters the data in the next combo box's row source

www.fmsinc.com

Cascading Comboboxes

How to create cascading comboboxes on a Microsoft Access form.

azlihassan.com