ChrisTheAncient
Technical User
I've been going round in circles until I'm not sure what I've done and tried. My brain cell has just imploded.
And I know the answer must be simple!!! That just makes it worse. Somehow I can't seem to find a similar problem in the FAQ's or search.
Anyway, the problem...
I'm making a 'progress through pre-defined tasks' type of database in Access XP - but will need to be able to convert it down to A97.
I have a very simple pair of tables...
tblProgressTask... that offers a series of pre-defined tasks (up to a set maximum of 25) applicable to all people in the database. Depending on the individual user of the database, not all tasks may be required.
tblProgress... that gives a 'completed' check and 'score' option for each Task on a person-by-person basis. This table, in turn, is linked to the main tblCustomers to provide the scores associated to each individual. If there is no pre-defined task because the full 25 are not needed, the task should not be displayed in the associated frmProgress.
In the frmProgress, I just cannot seem to find a way of displaying the Tasks from the tblTasks (or associated frmTasks) and make them as a label (that can be hidden if not used) for the 'complete' and 'score' fields.
I have been working on the basis that I imagine that the sub Form_Open() checks to see if there is indeed a need to display the label or not by using xxx.visible = false in the code. Unsuccessfully!
I did try a system of making a single line list box giving only one task as a label and that displayed beautifully. The only trouble is, I couldn't find a way of making that label invisible if there was no data in that table row.
My brain cell has now gone into total implosion and formed a black hole in my cranium and I'm admitting defeat on a simple question.
Can anyone save the sanity of me, and thus the wife and cat?
TIA
Chris
*************************************
OK, I'm stoopid. But I'm good at it!
*************************************