Query by Form within a macro

  • Thread starter Thread starter Tiffany - Billing Coord/Report Developer
  • Start date Start date
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!
 
Ok, I figured out how to work around this. I ended up creating a front end
form with a text box for the statement period ID to go into, hooked up all
the queries to run based on that field, then created all of my macros to run
the reports and hooked them up to buttons to put on the front end. This
worked a lot easier, plus provides a lot more functionality because I even
created another set of fields for a range and told the queries to look at the
single statement period box and, if empty, pulls based on the range instead.
Then the same buttons serve double functions. :-)

I'm still new to building front-ends so you might all know this but
hopefully it may help someone that's a self-learner like me!
 
Back
Top