Hi Guys,

I have been looking around in many forums. I would like to make my
macro to run again after i have entered info and hit enter.

The thing is that I have an Append query and I would like for it to
repeat it self or ask again as soon as I hit enter.

The only way I have seen I can do this is just putting many
OPENQUERY's in the macro design.

Can anyone help me do this......

On Aug 31, 4:54*pm, LUIS ANGEL <upslavazq...@gmail.com> wrote:
> Hi Guys,
>
> I have been looking around in many forums. I would like to make my
> macro to run again after i have entered info and hit enter.
>
> The thing is that I have an Append query and I would like for it to
> repeat it self *or ask again as soon as I hit enter.
>
> The only way I have seen I can do this is just putting many
> OPENQUERY's in the macro design.
>
> Can anyone help me do this......

Use the "lost focus" event in the field you're hitting enter on and
set it to your macro...

On Aug 31, 4:54*pm, LUIS ANGEL <upslavazq...@gmail.com> wrote:
> Hi Guys,
>
> I have been looking around in many forums. I would like to make my
> macro to run again after i have entered info and hit enter.
>
> The thing is that I have an Append query and I would like for it to
> repeat it self *or ask again as soon as I hit enter.
>
> The only way I have seen I can do this is just putting many
> OPENQUERY's in the macro design.
>
> Can anyone help me do this......

You can trap the enter key behavior. Set this to your on keypress to
trap the enter key behavior...

If KeyAscii = vbKeyReturn Then
KeyAscii = 0
docmd.runmacro "MyMacro"
End If