<!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 6.00.2800.1141" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Virginia</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>...there are 2 ways off the top of my head 1)
use the openargs to pass the RequestID 2) or use an ifthen in the onopen of form
3 to determine whether form 1 or 2 is open and set your filter accordingly
...probably other ways as well but HTH :)</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>William Hindman<BR>"And so, my fellow Americans: ask not what your country
can do for you - ask what you can do for your country. My fellow citizens of the
world: ask not what America will do for you, but what together we can do for the
freedom of man." John F. Kennedy, 1961</DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=HollisVJ@pgdp.usec.com
href="mailto:HollisVJ@pgdp.usec.com">Hollis,Virginia</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Monday, March 17, 2003 7:44
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [AccessD] One form for all</DIV>
<DIV><BR></DIV>
<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></BLOCKQUOTE></BODY></HTML>