firstly i'll admit know next to nothing when it comes to Access, i've just got my head around setting up a relational database so i am getting there slowly, but if your suggestions involve using code (i imagine it would) could you please tell me exactly where to put it ie. in the expression builder, or in a macro or whatever.
as the title suggests i would like a field to appear in form view if a checkbox is ticked. i would like to use this twice in my form - the first time the field that appears is just going to be a simple text field, but the second time i want to use it the field that appears is going to lookup data from another table - i don't know if this makes a difference to the code.
Also if the box is then unticked i would like the fields to disappear - i don't mind if the data that was entered in the field when the box was ticked is retained or not
is there anywhere online that lists the expressions and how to use them? or even a semi-advanced user manual for Access 2010 (or 2007)? i've had a quick google but can't find anything
thanks in advance for your suggestions - i know it will be an easy 500 points for the Access wizards out there