running depending field value

[bendiver]

i have a form that has a category field, i need to change what form is opened by a macro depending what value is entered into this category field is this possible. I suspect it may have something to with the arguments field in a macro, is this correct. Thanks to whoever takes the time to answer or even read my question.

 

[pcs]

the macro builder doesn't show by default the conditions column. the arguments are for a different purpose; like opening a form to display only selected data. you want to use the macro conditions which control when a macro action executes.

look under help for:
macro actions, conditional
then select:
Make a macro run under specific conditions

you can set up a series of openform actions in your macro that are conditionally based on your category field...

hth,
al



[This message has been edited by pcs (edited 08-11-2001).]

 

[pcs]

pat is correct. code is much simpler to use in a lot of ways than a macro and gives you more flexibility. i made the assumption, that since you were not aware of the conditional execution of a macro, that you were not quite ready to transition into using code.

access is a very big 'tool box' and provides many ways of accomplishing the same task. a macro is just one of the tools; but often not the best one. however, learning how to use conditions to execute a macro will help you to learn VBA, as the condition criteria are very similar to the code you would use.

in any case, if you prefer to use a macro the info i provided is correct. but, you should probably make an effort to start your migration to the 'wonderful world of VBA'

.

al




[This message has been edited by pcs (edited 08-11-2001).]

 

[bendiver]

Thanks guys thisi informtion has been extremely helpful and made my database work exactly how i needed it to. Its now perfect. Just a quick question. I get lost in visual basic code so can you reccomend a book or website to help me through the use of this code. Also does the change between macro's and code make any difference to the perfrmance of the database in generl terms. Thanks again folks you have been extremely helpful!!!!

 

[pcs]

imho, macros are slower in execution and slower to write as you have to make so many entries to accomplish an action. i don't think i've used a macro in years.

here are some links for book,etc.
http://www.access-programmers.co.uk/ubb/Forum7/HTML/001791.html http://www.access-programmers.co.uk/ubb/Forum1/HTML/001700.html http://www.access-programmers.co.uk/ubb/Forum1/HTML/003014.html http://www.access-programmers.co.uk/ubb/Forum1/HTML/003775.html http://www.access-programmers.co.uk/ubb/Forum1/HTML/004090.html http://www.access-programmers.co.uk/ubb/Forum1/HTML/004047.html http://www.access-programmers.co.uk/ubb/Forum7/HTML/001512.html http://www.access-programmers.co.uk/ubb/Forum7/HTML/001048.html


good luck,
al