M
Matt Williamson
I just started really playing with advanced features in Access97 and I'm
stuck trying to figure out how to do this latest idea.
Right now I have a Form with 4 textboxes that populate information in 4
unbound textboxes on a Report directly. I created a macro based upon the
help topic "use a form to enter report criteria" and it works nicely. The
report runs, the dailog pops up and gets populated then Hides itself when an
OK button is pressed. I want to put an intermediate step in where the form
checks for the values in a table first and populates the form's textboxes
with the data it finds. If there is no data, I want to create the data from
the values input into the form. I've been trying to do this by setting the
control source of the textboxes to a table that I created and populated with
a few values, but I don't think I'm getting the syntax correct.
My table is named "Outside Funds" and 2 Fields setup like so:
Outside Funds YTD Perf
Fund1 13.2%
Fund2 8.9%
Fund3 9.6%
Given that, can I put something in the control source of the textbox that
will pull the YTD Perf for Fund1,Fund2, etc? If it's not that easy, is there
another/ better way to accomplish this task?
TIA
Matt
stuck trying to figure out how to do this latest idea.
Right now I have a Form with 4 textboxes that populate information in 4
unbound textboxes on a Report directly. I created a macro based upon the
help topic "use a form to enter report criteria" and it works nicely. The
report runs, the dailog pops up and gets populated then Hides itself when an
OK button is pressed. I want to put an intermediate step in where the form
checks for the values in a table first and populates the form's textboxes
with the data it finds. If there is no data, I want to create the data from
the values input into the form. I've been trying to do this by setting the
control source of the textboxes to a table that I created and populated with
a few values, but I don't think I'm getting the syntax correct.
My table is named "Outside Funds" and 2 Fields setup like so:
Outside Funds YTD Perf
Fund1 13.2%
Fund2 8.9%
Fund3 9.6%
Given that, can I put something in the control source of the textbox that
will pull the YTD Perf for Fund1,Fund2, etc? If it's not that easy, is there
another/ better way to accomplish this task?
TIA
Matt