Checkbox issue

  • Thread starter 131313 via AccessMonster.com
  • Start date
1

131313 via AccessMonster.com

Hello,

I have a form that has checkboxes for each certificate (there are 8).
The control source for each checkbox is as follows:
=IIf([Certificate code] In ("TDP0100"),1,0)

This checks to see if required certificate is complete, if so box is checked.
Each box has a different certificate code.
The problem I'm having is that when in form view, if the person has more than
one certificate complete, they do not show up on the same view (the second is
there but I have to tab to see it). How can I get the form to show all
certificates completed for that person in one view?

Thanks
 
L

Larry Linson

I haven't a clue from what you write as to what your form looks like, what
data you have, and, thus, not even a guess at why "they do not show up on
the same view". If you'd clarify what you have, and what you are trying to
accomplish, perhaps someone could give you some useful suggestions.

If you have a People Table, then you should probably have a Certificates
Table related to the People Table... if so, then it may be that Checkboxes
aren't the best way to display the information. It might be better to show
the completed Certificates in a Form embedded in a Subform Control.

Larry Linson
Microsoft Access MVP
 
Top