Setting the value of a choice in a combo box

D

Daniel

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!
 
J

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!
Click to expand...

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]
 
Top