Assigning a Value to a Choice Field

  • Thread starter Musa via AccessMonster.com
  • Start date
M

Musa via AccessMonster.com

Hello,

I'm using Teleform software with VBA capablities.
I have the following
Field Type : Choice Field
Data Type : Numeric
Length : 2

I'm trying to assign the number 8 , if the Field. Status = Const FldTooMany
(If the person marked off more than 1 choice) The values are 1=Yes, 2=No,
and 88=Other


Private Sub Form_Evaluate()
Const FldTooMany = 8
Const FldOK = 0

If B5.Status = FldTooMany Then
B5.Value = 8
Else
B5.Status = FldOK
End If
End Sub

I can't seem to assign the value. A blank field appears on export.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top