If you are going to have a number of options for A, I would recommend using a case statement rather than multiple if, then, end ifs
e.g,
Select Case A
Case "All"
b = ......
Case "Some"
b = ....
Case Else
b = ....
End Select...
Is there any way using VBA I can control which folder first opens when adding files to an attachment field?
It seems to default to the last folder opened which is no good as i want each record to "point" to a different folder by default
e.g. c:\docs\record1 c:\docs\record2 etc