I've got two forms (with text boxes) linked to two tables.

By writing into one text box on one form I would like the same text to 

appear in related text box on the second form.

Can anyone help?

Henry. 

Use AfterUpdate event.



for example:



Private Sub dtmFirstFormStartDate_AfterUpdate()

On Error GoTo Err_frmFirstFormStartDate_AfterUpdate



    forms!frmSecondForm!dtmSecondFormStartDate  =3D me!dtmFirstFormStartDat

e

  

Exit_fdtmFirstFormStartDate_AfterUpdate:

    Exit Sub



Err_dtmFirstFormStartDate_AfterUpdate:

    MsgBox Err.Description, vbCritical, "Error Updating First Form Start 

Date!"

    Resume Exit_dtmFirstFormStartDate_AfterUpdate

End Sub



____________________________________________________



John Fejsa

Systems Analyst/Computer Programmer

Hunter Centre for Health Advancement

Locked Bag 10, WALLSEND NSW 2287

Phone: (02) 4924 6336 Fax: (02) 4924 6209

www.hcha.org.au

____________________________________________________



The doors we open and close each day decide the lives we live

____________________________________________________



CONFIDENTIALITY & PRIVILEGE NOTICE

The information contained in this email message is intended for the named 

addressee only.  If you are not the intended recipient you must not copy, 

distribute, take any action reliant on, or disclose any details of the 

information in this email to any other person or organisation.  If you 

have received this email in error please notify us immediately.



>>> hdh.napier@c... 22/02/2002 10:35:37 >>>

I've got two forms (with text boxes) linked to two tables.

By writing into one text box on one form I would like the same text to

appear in related text box on the second form.

Can anyone help?

Henry.








This message is intended for the addressee named and may contain confidential information. If you are not the intended recipient,
please delete it and notify the sender. Views expressed in this message are those of the individual sender, and are not necessarily
the views of Hunter Health.

Henry,



> I've got two forms (with text boxes) linked to two tables.

> By writing into one text box on one form I would like the same text to 

> appear in related text box on the second form.



Assuming both forms, Form1 and Form2, are open and that Form1 is on top 

(has the focus), and the text box name is txtEntry, put this on the text 

box's "On Update" event.



Forms![Form2].txtEntry = Me.txtEntry



If Form2 is a SUBform in Form1 then it's slightly different:



Me.[Form2].Form.txtEntry = Me.txtEntry



Greg



BTW... any relation to Jack Napier... aka The Joker? <grin>

Use the after update event for the first text box:



assuming you type into frm1 and want it to appear in frm2 (txtbox in both

forms)



forms!frm2.txtbox = me!txtbox





Click on the txtbox on frm1 and in properties click on afterupdate.  Choose

event procedure from the list then use the ... button to get into the vb

window.  Type the above into the space and away you go.



(You must have both forms open to do this)



Regards,



Richard Gibson

IT Manager

Walkerpack Ltd

01604 760529



-----Original Message-----

From: Henry Napier [mailto:hdh.napier@c...]

Sent: 21 February 2002 23:36

To: Access

Subject: [access] TEXT BOX





I've got two forms (with text boxes) linked to two tables.

By writing into one text box on one form I would like the same text to 

appear in related text box on the second form.

Can anyone help?

Henry.