Form Text Value.

  • Thread starter Thread starter Sigh
  • Start date Start date
S

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.
 
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
 
Back
Top