Bart
Member
Registered: 19th Aug 02
Location: Midsomer Norton, Bristol Avon
User status: Offline
|
Im trying to create something in Access and was wondering if anyone could help/point me in the right direction.
I have a number of tick boxes on ‘form1’.
Depending on which tick boxes are ticked, id like to display some standard text in a box located on ‘form2’.
The text will always remain the same.
e.g
On Form1:
Box1 and box4 is ticked.
On Form2:
It now displays:
Heres some text about box1
Heres some text about box4.
Can anyone point me in the right direction? I really don’t know access too well. Im using 2007.
Im assuming i will have to create a table with a column called title and label them respectively box1 to box5. Also create a column called comments and use my standard text.
How can i link the information through to the new form and only display text from the boxes which have been ticked?
[Edited on 15-04-2008 by Bart]
|
Bart
Member
Registered: 19th Aug 02
Location: Midsomer Norton, Bristol Avon
User status: Offline
|
right, ive kinda done this:
quote:
Private Sub Check6_Click()
Me.Comment.Visible = True
End Sub
Basically, if CheckBox 6 is ticked it displays 'Comments' box which is normally invisible.
Does anyone know how I can achive the following:
1) show/hide the comments box depending on whether the box is ticked? (if I tick the box it displays it, if i untick the box it remains there).
2)How can I reference a check box from another form?
|
