Value from 1 dropdown to determine available choices in next dropdown

[markzaal]

Access 2010

Hi all,

I have a form with 6 fields (the table has 4):

1 date field (also 1 field in table)
3 combo-boxes (dropdown lists)(concatenate into 1 "activity" field in table)
2 text fields (2 fields in table)

I would like the value selected in the first dropdown list to determine what choices can be made in the second and third combo-boxes. It should also determine the fieldnames of the 2 text fields. For example:

combo1 combo2 combo3 text1 text2

Port: Quay:
In port -Working -Mobilization ...... .....
-Waiting on weather -Demobilization
-Waiting on client -Port-call
-Waiting on tide -In between projects
-Waiting on arrival crew -Other

Location: SOW:
DP trials -Following mobilization -Mobilization ..... .....
-Following port-call -Port-call
-Following transit -In between projects
-Following DP alarm -Other
-Other

It looks better in excel, but I think you can get the picture...
I want to concatenate the choice made in each of the 3 combo-boxes into 1 "activity" and then add the info from the 2 text-boxes.

Any help will be mucho appreciado!

Mark

I just saw the lay-out gets messed up so I added a screenshot of the excel sheet...

 

[jdraw]

Watch these fee video tutorials and see if it clarifies things
http://www.datapigtechnologies.com/flashfiles/combobox1.html
http://www.datapigtechnologies.com/flashfiles/combobox2.html

Good luck