Go Back   Access World Forums > Microsoft Access Discussion > Macros

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 04-10-2005, 02:50 AM   #1
pam_w_85
Registered User
 
Join Date: Apr 2005
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
pam_w_85 is on a distinguished road
Macro To Open Form

Hello,

Can anyone advise on the code I would need to open a form when a certain value is entered into the combo box? For example if 1FULL is selected the payment form will automatically open,

Thanks

Pam

pam_w_85 is offline   Reply With Quote
Old 04-10-2005, 01:54 PM   #2
astarbyfar
Registered User
 
Join Date: Apr 2003
Posts: 93
Thanks: 0
Thanked 0 Times in 0 Posts
astarbyfar is an unknown quantity at this point
This is quite tricky and my university lecturer took a whole month to explain this one so please bare with me. What you have to do is enter a new macro and go to View -> Conditions. You will know see that a new column has been added. You will now have to enter code similar to the example;

[Forms]![EPOS]![Size]="6"

This states that if the value 6 is entered in the field [Size] on the form [EPOS] then do the Action that is documented in the action column. In this case just do the usual Open form e.t.c. Hope thats pretty clear enough! I will post an example of the macro so you can see for yourself!
astarbyfar is offline   Reply With Quote
Old 04-10-2005, 02:00 PM   #3
astarbyfar
Registered User
 
Join Date: Apr 2003
Posts: 93
Thanks: 0
Thanked 0 Times in 0 Posts
astarbyfar is an unknown quantity at this point
Sorry

Sorry heres the macro
Attached Files
File Type: zip Macro.zip (6.7 KB, 109 views)

astarbyfar is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump




All times are GMT -8. The time now is 05:01 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
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