Hi All...
When I run this program in the IDE it works fine. When I run it as an
executable I get a Run-time error "5": Invalid procedure call or argument. I
think this is a known problem based on the knowledge base artical Q242347.
This block of code is being called right after a modal form has closed and
the focus has returned to the main form. Has NE1 got a work around for this.
With frmFind
.addCaption = "Caller Name to find"
.recordSource = "SELECT CallerName FROM qryCallers ORDER BY CallerName"
.Show vbModal
End With
If (Len(gFindString) > 0) Then
With adoRecordset
.MoveFirst '-- to make sure it starts a the first record
.Find "CallerName = '" & gFindString & "'"
If adoRecordset.EOF = True Then
iReturn = MsgBox("Agent Name: " & gFindString & _
" was not found.", vbCritical, App.Title)
Else
iReturn = MsgBox("Agent Name: " & gFindString & _
" was retrieved.", vbInformation, App.Title)
End If
End With
End If
Thanks in advance
meh