Similar data tranfer one to another

  • Thread starter Thread starter Nur Muhammad
  • Start date Start date
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)
 
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.
 
Back
Top