Combining two fields on subform based on main criteria

[Ben]

I have a main form that has a field called "InternalDeliverable". I have a
subform that has two fields called Directory and FileName. I have created a
new form called filelocation. I want to combine Directory and FileName and
create a hyperlink to that file based on InternalDeliverable <> Deliverable.

is that possible?

I created a query and it works, but i want it to happen on the form when
InternalDeliverable is not equal to Deliverable.

Thanks

 

[Ken Snell \(MVP\)]

On which form will the "expression" need to be run/built? On the "main form"
that has the "InternalDeliverable" field, on the subform on that main form,
or on the "filelocation" form?