Setting the value of a choice in a combo box

[Guest]

Hi,

I am trying to create a combo box with fields from Table1. The values
stored in these fields are based on a number of criteria from Table2. What I
want to do in theory is say this: If ChoiceAInTable2 = -1 OR
ChoiceBInTable2 = -1, Then ChoiceAInTable1 = -1.

How do I make this happen?

Thanks!

 

[John W. Vinson]

Hi,

I am trying to create a combo box with fields from Table1. The values
stored in these fields are based on a number of criteria from Table2. What I
want to do in theory is say this: If ChoiceAInTable2 = -1 OR
ChoiceBInTable2 = -1, Then ChoiceAInTable1 = -1.

How do I make this happen?

Thanks!

I'm sorry, this makes absolutely no sense to me.

What are the structures of Table1 and Table2? What field do you want selected
from the combo box? Where will that value be stored?

John W. Vinson [MVP]