A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Checkbox issue



 
 
Thread Tools Display Modes
  #1  
Old April 12th, 2007, 03:03 PM posted to microsoft.public.access.forms
131313 via AccessMonster.com
external usenet poster
 
Posts: 22
Default Checkbox issue

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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200704/1

  #2  
Old April 15th, 2007, 04:15 AM posted to microsoft.public.access.forms
Larry Linson
external usenet poster
 
Posts: 3,112
Default Checkbox issue

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


"131313 via AccessMonster.com" u32128@uwe wrote in message
news:70985938d26fa@uwe...
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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200704/1



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:51 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.