Type Mismatch

  • Thread starter Thread starter BFB
  • Start date Start date
B

BFB

I set up an option group on a form (option buttons). The
option values (1-9) are tied to a field [Status] through
Alpha Buttons- ie option value=1, filter [Status]="A
Closed Deal" The various status' "A Closed Deal", "B
Committed Deal" etc are from a drop-down menu on the form
and I think this is creating the type mismatch message.
Any thoughts?
 
When are you getting the type mismatch error message? on what actions? from
which code? from a query? More info please....
 
What type of Field is [Status] in your Table?

Generally, I only bind integral numeric Field to Option
group. What you can do is to create a look-up
Table "tlkpStatus" with Fields like:

StatusID StatusText
1 A Closed Deal
2 B Commited Deal
....

In other Tables that have the Status Field, store only the
StatusID. In your Form, bind the OptionFrame to the
StatusID and only use tatusText whenever you want to
display the Status.

HTH
Van T. Dinh
MVP (Access)
 
Back
Top