Bound Control

[janetkaye]

I have 2 controls on a form in which I enter numerical data. I want to have a
third control which chooses number 2 if it is not = 0 or else chooses number
1 and then puts this number is a field in a table.

 

[MacDermott]

Why store this value in a table?
Write a query which will retrieve it whenever you need it.

 

[Dan Artuso]

Hi,
Just bind your 3rd control to the desired field.
You can use code like this, perhaps in the Click event of a command button:

If Me.yourControl2 <> 0 Then
Me.your3rdControl = Me.yourControl2
Else
Me.your3rdControl = Me.yourControl1
End If

Obviously you have to substitute your actual control names.