<!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=320023012-17032003>Form 1: A form
that is used for requesting services - a data entry
form.</SPAN></FONT><FONT face=Arial size=2><SPAN
class=320023012-17032003></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=320023012-17032003>Form 2: Used by
the engineer to edit, update data from the request.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=320023012-17032003>Form 3: Additional
data form needed to open for the User & Engineer</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=320023012-17032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=320023012-17032003>The table has a
RequestID as the PK</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=320023012-17032003>A second table is
used to store additional data, with the RequestID as FK.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=320023012-17032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=320023012-17032003>I need Form 3 to
open from either Form 1 or Form 2. How do I set the RequestID FK to the PK
RequestID on Form 3? I placed the FK on Form 3 and set the default to
=Forms!Form1.RequestID. Of course this will not work on Form 2 because the
default value for RequestID references Form 1.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=320023012-17032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=320023012-17032003>I do not want to
create multiple forms to do the same thing - but if that is the only choice I
will. How can I have Form 3 open from Form 1 &/or Form 2 and set the
RequestID?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=320023012-17032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=320023012-17032003>Virginia</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=320023012-17032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=320023012-17032003></SPAN></FONT> </DIV></BODY></HTML>