I have seen several posts that come close to answering my question, but
none
I have seen have gone into how to do this in a Macro, so...
I am using Office 2007. I have created a small "statement period" form
where a 3 digit number is entered (financial re****ting - each month has a
special code) but I want to be able to connect this to several different
re****t. I have one macro where I need to open that small form, type in
the
code, hit enter, and it will pull into each query and output them as I
have
instructed on the form. The output functions work great, and the form
even
pops up at the beginning, but when I type in a code (ex: 121) and hit
enter,
nothing happens. Do I need for this form to be connected to a table in
order
for it to work? I tried using the "afterupdate" condition on the first
query
but that's not working. Help! :-) Thank you!
|
