Similar data tranfer one to another

N

Nur Muhammad

Dear Friend:
In a Form, there are Three Text Boxl, like txt1, txt2, txt3 and they contain
contact Address, Residence Address, and Parmenent Address respectly.
At first I entry Contact Address, then i entry Residence address.
My Question is that:
If my residence address is similar with Contact address, then i don't want
to entry againg, I want to copy, but not use shortcut system, just want
using drop down list in the residence address which are link with contact
adress data

Pls Help me

Thanks
Nur Muhammad
(e-mail address removed)
 
D

Doctor

Create a Macro: in the action column, choose SetValue. Then at the bottom of
the window, in the Item choose build and find the box in the form that you
want to update with the information. Then in the Expression choose the item
that you want to copy the information from. For instance Item would equal
Residence Address. And Expression would equal Contact Address. Make a new
SetValue row for as many fields as you want to copy to the residence address.

Then in your form create an unbound check box; then in the OnClick event for
that check box choose the Macro that you just created.

Everything should copy fine.
 

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.

Ask a Question

Top