By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,491 Members | 879 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,491 IT Pros & Developers. It's quick & easy.

MultiTable runtime parameter

P: n/a
How does one set up a multi table runtime parameter based on fields
selected from Combo boxes (4 to be exact) for a form or report. Yes
it is possible I have seen it but not in Access.
I need some clues as I have tried different options without success. ie
SQL statement,filterproperty .
Regards

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
you can create a filter using VB and then open the report passing the
filter in the open event of the report.

I may have misread your question - if so, could you give an example to
clarify?

Nov 13 '05 #2

P: n/a
Example: Client master table -with a link for members of a common
group( may or may not apply to client ) Customer table with for
outstanding balances on account.
A form/report desined from Customer.table.At runtime you may want a
collective or a selective report for a particular report.ie group by
link or ungrouped.
From the Combo Box select Table : Client
From Combo2 select : link from table
From Combo3 select : =
From Combo4 optionally to expand on selection or save

Additional problem : Having selected fields and operators ,a filter
form should pop up showing the fields descriptions selected with
textboxes for users to enter the values at run time.
The next time the report is required it may be on client.resigned
field or a client.type field from the table client.
The common field for the two tables is a client reference filed.
It is this flexibility that I am after and hope that my problem and
goal is a bit clearer
now.
Thank you for your reply.

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.