Ok, so I have now got a working image database that works a charm. I have successfully added various check boxes and search (filter) criteria using what I learnt so far from help on this forum so I'm very happy!
My next task is to have a button appear if a check box on a row is checked; there are multiple rows on my form and I only want the button to appear on lines where that tick box is checked.
Ultimately, the button in question will be clicked for users to open a .PDF file; the path of which is stored in the table for this form.
I have been using the following syntax but can only make the button appear on ALL lines or none of them.
If Me.Check60 = -1 Then
Me.Command62.Visible = True
Else
Me.Command62.Visible = False
End If
Excuse the naming, but Check60 is the tickbox in question, and Command62 is the button I want to appear.
The tick box is automatically checked based on information in the table; nothing is "updated" as such when the form is being viewed.
I have read on some websites that this simply isn't possible - buttons can only be shown "all or nothing"... is that true? I cant find an alternative solution without having the full path of the PDF file shown - which to me just looks untidy (hence why I want to swap it to a simple button).
Thanks as always,
Chris
My next task is to have a button appear if a check box on a row is checked; there are multiple rows on my form and I only want the button to appear on lines where that tick box is checked.
Ultimately, the button in question will be clicked for users to open a .PDF file; the path of which is stored in the table for this form.
I have been using the following syntax but can only make the button appear on ALL lines or none of them.
If Me.Check60 = -1 Then
Me.Command62.Visible = True
Else
Me.Command62.Visible = False
End If
Excuse the naming, but Check60 is the tickbox in question, and Command62 is the button I want to appear.
The tick box is automatically checked based on information in the table; nothing is "updated" as such when the form is being viewed.
I have read on some websites that this simply isn't possible - buttons can only be shown "all or nothing"... is that true? I cant find an alternative solution without having the full path of the PDF file shown - which to me just looks untidy (hence why I want to swap it to a simple button).
Thanks as always,
Chris