<!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>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2><SPAN class=220202712-28072003>I need a form
to open from a command button that will be used to check for the
latest revision of a document. I want it to compare several fields, document
number, department, revision, change. Or at least document number &
department.</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=220202712-28072003>Example of number:
</SPAN></FONT><FONT face=Arial size=2><SPAN
class=220202712-28072003>DIVS-WR1450-M001, Rev 0, Ch A</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=220202712-28072003>The WR1450 is the
ESONumber TEXT (this number is always either WR1450 or
W34500)</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=220202712-28072003>M is for the
department (in this example - M is for Mechanical, there will be C-Civil,
E-Electrical) TEXT</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=220202712-28072003>001 is a sequential
number for the document</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=220202712-28072003></SPAN></FONT> </DIV>
<DIV><SPAN class=220202712-28072003></SPAN><FONT face=Arial size=2><SPAN
class=220202712-28072003>I want to assign the next sequential number, Revision,
Change for each DIVS based on the project number. I wasn't able to figure out
how to have the numbers assigned automatically based on 4 factors, so I thought
I would just have another form open and get the next numbers from there based on
what was showing as the last number used.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> stDocName =
"frmDIVSRevisions"<BR> <BR> stLinkCriteria =
"[ESONumber]=" & "'" & Me![ESONumber] And "[cboDept] = " & " '"
& Me!Department<BR> <BR>
DoCmd.OpenForm stDocName, , , stLinkCriteria</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=220202712-28072003>Virginia</SPAN></FONT></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV><FONT face=Arial
size=2></DIV></BLOCKQUOTE></BLOCKQUOTE></FONT></BODY></HTML>