Bound Control

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Why store this value in a table?
Write a query which will retrieve it whenever you need it.
 
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.
 
Back
Top