how to set a data source for a combo box with macro and not with vba

[mana]

hello

I have a form in ms access web database and two combo boxes in it. the valuse of the second combo box depens on the values of the first combo box. for example if the value of the first combo box is selected as 'text1' then the values of combo2 will be tex3,tex4,tex5 and if the value of the firs combo is 'text2' then the values of the second combo are tex6,tex7,tex8 and so on.
but in access web services it is not possible to work with vba. do you know how i can do it with macro?
thank you for your help

 

[vbaInet]

You need to give us some real examples.

And you'll probably get more help if you posted this in the 'Access Web' forum.

 

[mana]

what should i do now? should i post it in access web again?
what do you mean with real example?
it is real just the values are different.

 

[vbaInet]

Real examples = real non-confidential values.

 

[mana]

ok the values of combo 1 are GPD,design and project management if gpd is selected the values of combo2 should be :mbu1,mbu2,quality,log.
if project management is selected then the values of combo2 should be : investment and e&e analagen.
do you know how to do this?

i have also another qustion, sorry but i am new to access web and when i create a form i 'm not able to change the textboxes size or place when i change one of them all of them will be changed together. do you know how to create a form to change the size of the text boxes.

thank you

 

[vbaInet]

I don't use Access Web simply because I don't like data macros.

Can you list it out in a legible format, i.e.:

Combo1:
----------
1, GPD
2, Design
3, Project Management

 

[mana]

Hello,

sorry for late answer, i don't like it also but unfortunately i need web application
i attached the format
thank you

 

[khurram7x]

Ok, I've not tried this but SetValue is a Macro function that manipulates with RowSource of Combo Box, but it is not available for web database.
Requery is available from Macro's and setting it up on SetFocus event should work.

 

[vbaInet]

Ok, by attaching something without any explanation doesn't help. I don't understand what you attached.

 

[mana]

i can't understand what you mean
can you explain more please what i should exactly do?

 

[vbaInet]

I don't understand the data you uploaded.

 

[mana]

if

Combo1:
----------
1, GPD
2, Design
3, Project Management

----if design from combo1 is selected

Combo2:
----------
1, Rear HPL
2, Front HPL & PTO
3, Fuel tank DEF tank, Fuel Tanks support, DEF lines, Fuel lines
4,ATS (After treatment System) and supports
and so on like attachment

----if GPD from combo1 is selected
Combo2:
----------
1, MBU1
2, MBU2
3, Quality
4,LOG
5,Safety
and so on like attachment

if Projektmanagement from combo1 is selected
Combo2:
----------
1,Investment
2, E&E Anlagen (Programmierstationen, AQIS,…)

 

[mana]

the first if is wrong

 

[MSAccessRookie]

I am not a VB.Net Expert, so I am not sure that I understand what the complete scope of your issue is, but the link below may apply to your situation.

-- Rookie

http://www.tutorialspoint.com/vb.net/vb.net_combobox.htm

 

[mana]

Hello,

Do you have other ideas?
I have still the problem

 

[khurram7x]

I'm attaching a small sample 2010 database. like i said, we cannot use SetValue macro in web database, so i've used Requery to do the same thing.

Open the form, make a choice and see it it works. Then look at the Query and 'After Update' event of first Combo.

Hope it helps, if I understood correct what you're looking for )

BTW: Table is not normalized. I'ld leave for you.

 

[vbaInet]

Looks like Khurram7x is on it. I'll be in the background.

 

[mana]

hello

thank you
but in access web it is not possible to set the criteria in query.
i attached the files as well

 

[vbaInet]

Upload the db.

 

[mana]

Hello,

i uploaded the DB.
my form is main1 and table1 and query1