Form Text Value.

[Sigh]

Hi,
I create two forms. One form call frmDate. It have two
text box with date value. Other form call frmquery also
have two text box. When I input the date value into form
frmDate and close it. I would like my form frmquery
automaic have the same value date like my frmDate text box.

Any help would be very appreciated.

 

[Dennis Schmidt]

Hi Sigh,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

There are many different ways to resolve this issue. I present one way of
doing it. This presumes that the frmQuery is open at the time you close
the frmDate.

1-Open the frmDate form in design view
2-Add a button to the form (to close the form)
3-Select the OnClick Event in the property window and select CodeBuilder
4- Type the following code:

Forms![frmQuery]![NameOfTextboxA] = Me![NameOfTextboxA]
Forms![frmQuery]![NameOfTextboxB] = Me![NameOfTextboxB]
DoCmd.Close

This will place the values from the textboxes on the frmDate into the
textboxes of the frmQuery and close thefrmDate.

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support