Code for Send Keys

[Plien]

I used macro's with "Send Keys" action in Access 2000. This is to copy (often a choice from a "Combo Box") input from one field and paste it into another field where notes are kept.

In Access XP macro's with the "Send Keys" action won't work.

Is it possible to convert this macro into code, and if so, how do I do that? Would that solve the problem, are there better/other solutions?

Thanks!

 

[Jack Cowley]

If you want to put the bound field of a combo box into a field called MyField on the same form then this code in the After Update event of the combo box should do the trick (be sure and select [Event Procedure], click the 3 dot button to the right and put this between the two lines of code you will find when the code page opens):

Me.MyField = Me.ComboBoxName

hth,
Jack