Prev: AccessXP email thru Outlook2007
Next: Skip printing some pages in report
From: Karen on 17 Jan 2010 04:24
Hi
How do you get the text from one text box to be entered into two fields in
separate tables?
Thanks


From: hbinc on 17 Jan 2010 05:48
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 18 Jan 2010 06:18
"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

 | 
Pages: 1
Prev: AccessXP email thru Outlook2007
Next: Skip printing some pages in report