How to restrict drop down selections based on another drop down selection in the same form?

[Etoimos]

And yes, they will not be editable, I thought that was what you wanted.



Cheers,

Sorry, I missed that part. You are correct that I do not want them editable. I was just stating that the results I was getting were not what I wanted and were not editable.

[Gicu]

Have a look at this:

[Etoimos]

Okay, my Control Source for the text button was showing this: ScenarioCombo.[Column(3)] That was put in there when I clicked on the build button (...) in the Control Source field and then used the Expression Builder.

When I manually typed it to match what you have above (substituting my info), it worked like I want it to for the column 3 text box. If I put the same code and update it to (4) for the second text box, that text box does not get populated.

[Etoimos]

For my ScenarioCombo, I have it set to Column Count 4 and Column Widths 1" if that helps troubleshoot this issue.

[Gicu]

Remember I mentioned the column collection is 0 based (as most other Access collections are), to display the third column in the textbox you use =[ScenarioCombo].[column](2) and to display the fourth column you use =[ScenarioCombo].[column](3).

Cheers,

[Etoimos]

Remember I mentioned the column collection is 0 based (as most other Access collections are), to display the third column in the textbox you use =[ScenarioCombo].[column](2) and to display the fourth column you use =[ScenarioCombo].[column](3).

Cheers,

Yep, I've got a total of six column in that table. I am wanting to display column 4 (column 3 to Access) in the first text box and column 5 (column 4 to Access) in the secdond text box.

[Gicu]

For my ScenarioCombo, I have it set to Column Count 4 and Column Widths 1" if that helps troubleshoot this issue.

The fact that they are in the table is irrelevant, you need to have them in the rowsource of the check box.

[Etoimos]

I wish I could post some screen shots for you, but I can't.

To the ScenarioCombo combo box, I added columns 3 and 4 (0 based counting) to the Row Source.

To text box DurationText I added =[ScenarioCombo].[column](3)

To text box ThreatsText I added =[ScenarioCombo].[column](4)


Text box DurationText updates as I change ScenarioCombo as it should. Text box ThreatsText does not change (it is always just blank).

[Gicu]

To use =[ScenarioCombo].[column](4) you need to have the ColumnCount property of the ScenarioCombo>=5 (0,1,2,3,4) but you have it as 4.

Cheers,

[Etoimos]

I tried that earlier and again right now and ThreatsText still does not get populated with any data.

[Gicu]

Can you upload a small sample of your db with the table and the form?

[Etoimos]

My database has some data I can't post to public locations. Let me rebuild a generic database to mirror these tables and form that I can share.

[Gicu]

Of course, just the objects involved in the form and only a few "dummy" records.

[Etoimos]

It is too large for me to attach here on the site and I can't get it to compress on my company laptop.

[Etoimos]

Okay, I think I got it to attach:

TestDB.accdb