Field Options

[Stacey]

We have an Access database that has a field with 2 choices - "A - Been
Recommended" and "B - Has Not Been Recommended". When we choose one of the
answers in any record, it changes all the records to that choice. Why would
this be?

Also, regardless of the choice, A or B, when we print, all the records show
as if choice A has been selected.

Any help will be greatly appreciated.

Thank you very much.

 

[Dirk Goldgar]

We have an Access database that has a field with 2 choices - "A - Been
Recommended" and "B - Has Not Been Recommended". When we choose one of
the
answers in any record, it changes all the records to that choice. Why
would
this be?

Also, regardless of the choice, A or B, when we print, all the records
show
as if choice A has been selected.

Any help will be greatly appreciated.

Thank you very much.

It sounds to me like you are doing this on a form, and the control you are
using to select the choice is unbound -- that is, it has a blank Control
Source property. Is that the case?