T
Tiffany - Billing Coord/Report Developer
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 reporting - each month has a
special code) but I want to be able to connect this to several different
report. 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!
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 reporting - each month has a
special code) but I want to be able to connect this to several different
report. 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!