By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,098 Members | 2,007 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,098 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 .

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

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 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
Thank you for your reply.

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.