Dynamic reports

[amonadi]

Hi,



I would like to get guidance on how to do a particular type of access (2007) report. I am very familiar with sql but new to access.

I have two basic tables. table A which contains static values + and ID and a table B which contains text field and an ID which maps to ID of table A.

I would like to find out how i can place a text box which would be used to map content in text field of table B and a drop down menu with values of table A.

Ideally, user would fill the text box and select an item from the drop down box and press a submit button. When the submit button is pressed the result would be a report of query from the values inputed.

Can some one guide me on how i would be able to do such a thing?

Thank you!

[A S MANN]

You need to create a query with both Table A And B. Connect them by using ID as commmon field. Varify the data properly in query.
Creat a Form. In form Property in Record sourse field write name of quey.
Add Text box field and link it's Control sourse field to concern field in table B
Add Combobox field and link it's Control sourse field to concern field in table A
in raw source write SQL eg SELECT [Field A] FROM Table A; Use ... as tool to design the query as source.
Add Command button name as submite and use wizard to preview a report.
Create a report with desired fields
Data can be restricted to one selected at form by selecting the filter condition as tableA.ID=TableB.id .
Reply if you want more details.