Open a Report using a Form Edit | Delete | Quote | Reply

---

Hello Every1

I m new to this platform. I m having a problem with the Forms in MS Access. I want to keep a textbox and a Command button on the form and user enters particular input data into the textbox and when I press the command button the particular report should open according to the user input from whole lot of reports.

Please advice anyone

ksrhyd

One way that might be useful is to use some VBA code. It's been a few years since I've used Access so it may no longer be pertinant and my help can't really go futhur.

I've thought that using syntax like:

[FORMNAME]![CONTROLVALUE] to get data from a control. If you can do that from within a query (instead of using COLUMN = "value" do COLUMN = [A]!) and use that query as the basis of your report.

Can't help you much further, sorry