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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|