Go Back   Access World Forums > Microsoft Access Discussion > Macros

Thread Tools Rate Thread Display Modes
Old 07-11-2005, 10:13 AM   #1
Newly Registered User
Join Date: Jul 2004
Posts: 599
Thanks: 7
Thanked 1 Time in 1 Post
fenhow is on a distinguished road
Need a Open Form Macro


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.


fenhow is offline   Reply With Quote
Old 07-13-2005, 08:16 AM   #2
Registered User
Join Date: Jul 2005
Posts: 23
Thanks: 0
Thanked 0 Times in 0 Posts
IanWright is on a distinguished road
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..
IanWright is offline   Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Filter Form Open In Macro jgd12345 Macros 5 04-26-2004 08:27 PM
Open new form based on a value entered in current form cinders Forms 3 04-09-2004 01:40 PM
open a form from another form for same customer sparker2 Forms 1 12-15-2002 12:35 PM
Macro to open record in form from another form trackmedic Macros 1 11-26-2002 09:20 AM
Open a form with current record hilbertm Modules & VBA 9 10-15-2001 11:31 PM

All times are GMT -8. The time now is 02:47 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World