<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.00.3314.2100" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN class=310382615-11102003>I am having problems
with a formatted field. The FailureReportNo is a number
field.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=310382615-11102003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=310382615-11102003>On a search form, I
want to double-click on the failure report number and open another form that
contains all the failure data.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=310382615-11102003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=310382615-11102003>On the search form I
have the FailureReportNo with the Control Source: </SPAN></FONT><FONT face=Arial
size=2><SPAN
class=310382615-11102003>=Format([FailureReportNo],"""EF-""00000")</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=310382615-11102003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=310382615-11102003>On the double-click
of the FailureReportNo I have:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT size=2><FONT face=Arial><SPAN
class=310382615-11102003> </SPAN>stLinkCriteria =
"[tblSystemMain].[FailureReportNo]=" &
Me![FailureReportNo]<BR> DoCmd.OpenForm stDocName, , ,
stLinkCriteria<BR> DoCmd.Close acForm,
"frmFind"</FONT></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=310382615-11102003>The problem is the
search form FailureReportNo field contains #Error & if I double click on the
field (to test it anyway) I get Type Mismatch. Do I have my quotes
wrong?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=310382615-11102003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=310382615-11102003>Virginia</SPAN></FONT></DIV></BODY></HTML>