i think i need to clarify a bit more on this; the hyperlink field data
is programically input. I think this is the reason it does not give me
an option to add more, because i am not typing directly into the field.
Private Sub Command18_Click()
On Error GoTo Err_Command18_Click
Dim lngFlags As Long
Dim strfilter As String
Dim strPathAndFile As String
Me.AllowAdditions = True
Me.AllowDeletions = False
strfilter = ahtAddFilterItem(strfilter, "Word Documents (*.doc)",
"*.DOC")
strfilter = ahtAddFilterItem(strfilter, "Excel Documents (*.xls)",
"*.XLS")
strfilter = ahtAddFilterItem(strfilter, "All Files (*.*)", "*.*")
strPathAndFile =
ahtCommonFileOpenSave(InitialDir:="\\department\sh are\", _
Filter:=strfilter, FilterIndex:=3, Flags:=lngFlags, _
DialogTitle:="Choose a File")
If Len(strPathAndFile) > 0 Then
'MsgBox "You selected: " & strPathAndFile
[Form_Gains Chart]!AttachmentLink.Value = Right(strPathAndFile,
Len(strPathAndFile) - InStrRev(strPathAndFile, "\")) & "#" &
strPathAndFile & "#"
Else
MsgBox "You didn't select a file"
End If
Exit_Command18_Click:
Exit Sub
Err_Command18_Click:
MsgBox "Error " & Err.Number & " : " & Err.Description & " in
Command18_Click", vbExclamation, "Model Scoring Form 4"
Resume Exit_Command18_Click
DoCmd.Save
End Sub