Form

[kiranair]

I have a form which contains cascading combo boxes , text boxes , auto fill based on selection of combo boxes .


My question is ,I have to fill a certain text box based on the another 4 tables , first I have to select 1 table out of 4 based on the situation then inside the table i have data with field names option1,option2,option3, i have to select 1 option which is feasible each option is having certain data I have to select 1 and that has to be in my text box of the form

Eg i have attached a screenshot of a example data in which total weight is my data that has to be filled in text box

to do this activity i need your suggestions

Thanks in advance!!!

[ranman256]

do you want to load Access combos or Excel combos?

[kiranair]

Access combos

[kiranair]

i want to load access combos but am not getting idea how to do this .
Bcz when i enter the text box i need to look for table 1-4 then i ll select which option is convenient for my form, then i ll look for available options 1-3. then i ll select one option and data selected has to be my entry od data into form and then on to table