<!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.50.4916.2300" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=241045216-23072003><FONT face=Arial color=#0000ff size=2>The
trick is to not close the form, hide it instead. </FONT></SPAN><SPAN
class=241045216-23072003><FONT face=Arial color=#0000ff size=2>Then, you can
refer to the control on the form from the calling form code. I am assuming
you are opening the form in dialog mode, so the calling form code pauses until
the dialog is closed or hidden. For example:</FONT></SPAN></DIV>
<DIV><SPAN class=241045216-23072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=241045216-23072003><FONT face=Arial color=#0000ff
size=2>'Calling form code:</FONT></SPAN></DIV>
<DIV><SPAN class=241045216-23072003><FONT face=Arial color=#0000ff
size=2>Private Sub cmdDialog_Click ()</FONT></SPAN></DIV>
<DIV><SPAN class=241045216-23072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=241045216-23072003><FONT face=Arial color=#0000ff
size=2> DoCmd.OpenForm "frmMyDialog",
WindowMode:=acDialog</FONT></SPAN></DIV>
<DIV><SPAN class=241045216-23072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=241045216-23072003><FONT face=Arial color=#0000ff
size=2> If CurrentProject.AllForms("frmMyDialog").IsLoaded =
True Then</FONT></SPAN></DIV>
<DIV><SPAN class=241045216-23072003><FONT face=Arial color=#0000ff
size=2> MsgBox
Forms!frmMyDialog!txtSelection & " was selected."</FONT></SPAN></DIV>
<DIV><SPAN class=241045216-23072003><FONT face=Arial color=#0000ff
size=2> DoCmd.Close acForm,
"frmMyDialog"</FONT></SPAN></DIV>
<DIV><SPAN class=241045216-23072003><FONT face=Arial color=#0000ff
size=2> End If</FONT></SPAN></DIV>
<DIV><SPAN class=241045216-23072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=241045216-23072003><FONT face=Arial color=#0000ff size=2>End
Sub</FONT></SPAN></DIV>
<DIV><SPAN class=241045216-23072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=241045216-23072003><FONT face=Arial color=#0000ff
size=2>'Dialog form code:</FONT></SPAN></DIV>
<DIV><SPAN class=241045216-23072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=241045216-23072003><FONT face=Arial color=#0000ff
size=2>Private Sub cmdOK_Click ()</FONT></SPAN></DIV>
<DIV><SPAN class=241045216-23072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=241045216-23072003><FONT face=Arial color=#0000ff
size=2> Me.Visible = False</FONT></SPAN></DIV>
<DIV><SPAN class=241045216-23072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=241045216-23072003><FONT face=Arial color=#0000ff size=2>End
Sub</FONT></SPAN></DIV>
<DIV><SPAN class=241045216-23072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=241045216-23072003><FONT face=Arial color=#0000ff
size=2>Private Sub cmdCancel_Click()</FONT></SPAN></DIV>
<DIV><SPAN class=241045216-23072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=241045216-23072003><FONT face=Arial color=#0000ff
size=2> DoCmd.Close acForm, Me.Name</FONT></SPAN></DIV>
<DIV><SPAN class=241045216-23072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=241045216-23072003><FONT face=Arial color=#0000ff size=2>End
Sub</FONT></SPAN></DIV>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Don Elliker
[mailto:delliker@hotmail.com]<BR><B>Sent:</B> Wednesday, July 23, 2003 11:40
AM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> [AccessD]
creating an inputbox form<BR><BR></FONT></DIV>
<DIV>
<DIV>
<P>Howdy,</P>
<P>I want to use my own form in place of the Inputbox. I am stuck on the part
where, after a user selection, I return the value selected. It's like this;
the user is on a form, makes a selection and up pops (my) inputbox. they pick
something and close it. How do I know what they picked?<BR>TIA,</P>
<P>_d</P></DIV><BR><BR><BR>"Things are only free to the extent that you don't
pay for them".-Don Elliker
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV></DIV><BR clear=all>
<HR>
MSN 8 helps <A href="http://g.msn.com/8HMRENUS/2743??PS=">ELIMINATE E-MAIL
VIRUSES. </A>Get 2 months FREE*. </BLOCKQUOTE><br><br>--------------------------------------------------------------------------------------------------------------------<br>This email and any files transmitted with it are confidential and<br>intended solely for the use of the individual or entity to whom<br>they are addressed.<br>If you have received this email in error please notify the<br>originator of the message. This footer also confirms that this<br>email message has been scanned for the presence of computer viruses.<br><br>Any views expressed in this message are those of the individual<br>sender, except where the sender specifies and with authority,<br>states them to be the views of Tappe Construction Co.<br><br>Scanning of this message and addition of this footer is performed<br>by SurfControl E-mail Filter software in conjunction with <br>virus detection software.<br></BODY></HTML>