From: Karen on
Hi
How do you get the text from one text box to be entered into two fields in
separate tables?
Thanks


From: hbinc on
On Jan 17, 10:24 am, "Karen" <kl...(a)bigpond.net.au> wrote:
> Hi
> How do you get the text from one text box to be entered into two fields in
> separate tables?
> Thanks

Hi Karen,

Define TextBox2 (if necessary hidden) with ControlSource the second
field.
In the AfterUpdate event of TextBox1 assign this value to TextBox2.

However, to me it does not sound database-like to store the same value
in different tables.


HBInc.
From: Keith Wilby on
"Karen" <klmei(a)bigpond.net.au> wrote in message
news:LHA4n.1848$pv.1096(a)news-server.bigpond.net.au...
> Hi
> How do you get the text from one text box to be entered into two fields in
> separate tables?
> Thanks
>

That would violate data normalization conventions. What process is it that
you'd like to achieve?

Keith.
www.keithwilby.co.uk