Recent content by Tim Curtis

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