Need a Open Form Macro (1 Viewer)

Hello,

I have a form that I would like to call from anywhere in my database. I would love it if i could use a series of keys to call the form and it pops up in front so I can use it. It is a search form. What is the easiset and cleanest way to do this? Any help would be greatly appreciated.

Fen

Well in Access you can create a macro to open a form, then you'd just have to call it.

I'd suggest creating a button to run a macro, and set it to run one that opens a form. Then copy that code and paste it in a new function. I think what you can do is an "on key press" function, so you could do that, and get it to run the macro if the key you want is pressed. I'm not too hot on VBA at the minute so heres some pseudocode!

new sub on_key_press()

if key_press="k" then
run load form macro
end if
end sub

just like that, you just need to figure out how to do the VBA to do that..