One combo depends on another doesent work

[scifo_dk]

Dear Experts.



I'm having some trouble with one of my databases.

In the enclosed file, I have a form, where the combobox "Kunde_årsagtilflowstatus" shows values from the table "tbl Årsag til flowstatus" where "[tbl Årsag til flowstatus].Flowstatus" is equal to the value on the "Flowstatus" field on the form.

However, if I try to change the value in "Årsag til flowstatus" on the form, it returns to the first post right away.

Does anyone have an idea on how to correct this?

Thanks alot

//Scifo

[apr pillai]

Change the Bound Column Property Value of the Combobox to 1 (now it is set as 2).

1. Open the Form in design view.
2. Click on the Combobox to select it
3. Click on the Property Sheet Toolbar Button to display the Property Sheet.
4. Find the Bound Column property and change the current value 2 to 1.

[scifo_dk]

Change the Bound Column Property Value of the Combobox to 1 (now it is set as 2).

1. Open the Form in design view.
2. Click on the Combobox to select it
3. Click on the Property Sheet Toolbar Button to display the Property Sheet.
4. Find the Bound Column property and change the current value 2 to 1.

This worked! thx alot