Linking queries to forms

A

Amin

So I have this query right now that uses a parametric input. What I would
like to do instead is have it use a scrollbar box on a Form. So instead of
typing in "Bill Stevenson", I can use this form to scroll down to Bill
Stevenson and this will result in a report opening.
 
G

ghetto_banjo

You could use a combobox or a listbox on the form, and after selecting
his name in that box, you could run the report (either by clicking a
button, or directly on the After Update event of the combo/listbox).

your criteria for the report instead of a parameter would be something
like

forms![formname].[combobox]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parametric queries 9
About queries and forms 2
Filtering Queries for Forms 2
Scroll bars missing. 3
Need Help Linking? 1
Creating forms from queries 1
Problem with Report and Forms 2
queries and forms 0

Top