Dependent fields with automatic filling in form (1 Viewer)

Senthil94 · Dec 9, 2017

Hi all im very new to Microsoft access .im intrested its features. So i want some help for following .
My data base
Equipment model part. description drawing no
Crusher. X125. X125001. Xyz. 1234.
X125002. Cvb. 5678
X125003. Zxc. 88890
Crusher. X250. X250001. Xyz2. 76578
X250002. Cvb2. 99087
X250003. Zxc2. 7820
Miner. Y500. Y500001. Abc. 57392
Y500002. Asd. 663427
Y500003. Ghj. 725272
Miner. Y625. Y625001. Abc2. 829202
Y625002. Asd2. 6540
This is the example data base please help me in form that if equipment field if i enter crusher then in model field it should show x125 and X250.if i enter miner means it should show y500 and y625. Then part field depend on model it should show X125001 or X125002. Like that after selection it shoud automatically fill the description field and drawing no field. Then during retrival of any records it should populate model and quipment field according to requirement. Please help me to solve . huge data is there above said only sample

NauticalGent · Dec 9, 2017

Greetings Senthil94,

I am not entirely clear on what you’re asking. I think what you are looking for is explained in Access as “cascading ComboBoxes”. In plain language it means that the options of one ComboBox is based on the contents of another.

If you search for “cascading combobox” in this forum or on Google, you should be able to find what you are looking for.

Good luck and if you get stuck, you could post your Database here so that I and others could assist.

Senthil94 · Dec 9, 2017

Thanks for your reply

Senthil94 · Dec 9, 2017

Sorry for in convenience. Im asking if i have 5 different type of machines and each have 4models that models having various individual parts.it is master data base
Then during despatch or any other application im creating one form .
inthat form containg datas like
1. Machine type
2.model
3.individual parts
And other extra datas
In that after typing the machine type field.the model field have to show the models depending on the machine type i selected in machine type field.
after that individual parts i have to select belong to that model only.
after selecting individual part that description and drawing no fields should filled automatically please help me to solve this

JHB · Dec 9, 2017

Post some sample data in a Database or Excel sheet, zip it because you haven't 10 post yet.

Senthil94 · Dec 9, 2017

I attached sample file here please help to solve

JHB · Dec 9, 2017

Try the Attached database.

NauticalGent · Dec 9, 2017

JHB,

I have seen a few examples of Cascading Combo's but I really like this one. Minimal VBA, Maximum (interactive) Access.

Thanks for posting.

JHB · Dec 9, 2017

You're welcome.

Senthil94 · Dec 11, 2017

JHB said:
Try the Attached database.

Thanks mr.JHB but i have an issue in your shared access data base u wrongly taken the sample.
That machine model part description should be in other table. It should fill to another table through form in that form i have to select based on first table.and it have to fill another fields automatically. It is possible or not .

JHB · Dec 11, 2017

I've 2 solution in the attached database, form "DataTable" and "ExampleForm"
Else you've to explain in another way what you way.

Senthil94 · Dec 11, 2017

Dear mr .JHBthank you for your solution but in that i got idea to how to dependency.
Another help
In querry how we can get datas from 2 different table in that machine sl no is same.
But the problem is i have to get 2machine sl no details in a single row.

Another one
is it possible to protect sheet user wise password protection

JHB · Dec 11, 2017

Senthil94 said:
..
In querry how we can get datas from 2 different table in that machine sl no is same.
..

If you mean how to fetch data from 2 tables, then use a Union query.
https://www.safaribooksonline.com/library/view/access-data-analysis/0596101228/ch01s10.html

Senthil94 · Dec 14, 2017

Mr .JHB i stuked up .ihave to create more than 150 combo box entries it is not allowing to save access file. So please help.is there any work around for that

JHB · Dec 14, 2017

I don't understand, could you show some screendumps what you want and what you problem is.

Senthil94 · Dec 14, 2017

U given 4combo box example na like that more than 150 combo boxes to be created but it is not allowing me to save the data base

isladogs · Dec 14, 2017

Are you saying you have 150 combo boxes that you want to link by cascading?
If so, that's not practical even if it's possible.

However, if you have 150 records for your combo, that's ok

Senthil94 · Dec 14, 2017

Ss i have mor than 150 combination like what i have given in sample.it is not possible ah
What is limit of maximum combo box per table

isladogs · Dec 14, 2017

It's a practical limit rather than a physical one

There is a limit of around 700 controls on a form so having 150+ comboboxes isn't the issue. It's the CASCADING part that will be the problem

The screenshot below shows 5 cascading comboboxes which is about as many as I'd ever use. In that case, the purpose is to allow users to select a postcode from a list of around 1.7 million records by breaking it down into parts. If I could use fewer combos to do this, I would do so

Theoretically, you could probably code 150+ combo boxes so that each depends on the one before (though I can't imagine any situation requiring that).
However, consider what that would be like for an end user having to click through every one of those to finally get to the final outcome. Its just not practical

Mark_ · Dec 14, 2017

Senthil94,
Do you have 150 fields in your table?
Do you have 150 records in your table?

Dependent fields with automatic filling in form (1 Viewer)

Registered User.

Ignore List Poster Boy

Registered User.

Registered User.

Have been here a while

Registered User.

Attachments

Have been here a while

Attachments

Ignore List Poster Boy

Have been here a while

Registered User.

Have been here a while

Attachments

Registered User.

Have been here a while

Registered User.

Have been here a while

Registered User.

MVP / VIP

Registered User.

MVP / VIP

Attachments

Longboard on the internet

Similar threads

Users who are viewing this thread