Using vba to link fields to trigger visible icon

[ksmith119]

I am trying to make an icon visible dependant on a field on another form being completed. I am able to get this to work with the following code


If Not IsNull(Book_Title) Then
Forms![frm_Author]![subfrm_AuthorProject]![Command22].Visible = True

BUT
this makes the icon visible for all projects the author has (which are shown in the (continuous) subform) .
The link field is projectID so how to I specify that in the above code

Essentially I want to say

If ProjectID=ProjectID then
If Not IsNull(Book_Title) Then
Forms![frm_Author]![subfrm_AuthorProject]![Command22].Visible = True

but of course this doesnt work

[NTC]

It can't be done they way you are attempting because a single command to a continuous form type affects all controls of the same name....which repeat in each record....

You must update the underlying record source (table) of the continuous form - perhaps a checkbox or some value in a new field....and then requery the continuous form - and the continuous form needs to be modified for conditional formatting of the command22 that toggles its visibility based on the new checkbox/value field within its row....