repeating a query

[LUIS ANGEL]

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......

 

[KLZA]

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...

 

[KLZA]

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