When do you want this to occur? You could use the AfterUpdate event of the
control or the AfterUpdate event of the record to do this with a simple
assignment statement similar to the following:
'From some event on Form 1
forms!form2.txtB=me.txtA
This saves the value in txtA on Form 1 to txtB on Form 2.
There are any number of solutions.
The most correct and easiest is to make sure that both forms are based on
the same table or query and both fields have the same source.
You'll have to post the code you've tried and tell me what is happening (or
what isn't happening that you expect to happen). Be specific - it's hard to
be helpful without having the relevant details.
Thanks,
--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.