Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / December 2005

Tip: Looking for answers? Try searching our database.

Parameter field in Reports

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
len - 09 Dec 2005 01:27 GMT
Hi There.  I have set up a query with a parameter field to print labels (full
page of the one).  As the first and last name are in different fields, the
last name field appears then the first name SEPARATELY.  is there any way a
paramater field can be a drop down box where the name is selected from a list
(it would need to show last name, fist name, middle name)... or is this
getting a bit complicated for a beginner?  Thanks  Len
Allen Browne - 09 Dec 2005 02:01 GMT
You cannot get a query to give you a combo box.

But if you set up a form, you can refer to the combo boxes on the form
instead of popping up parameter boxes.

I'm assuming you have a table of clients (named tblClient) with these
fields:
   ClientID      AutoNumber    primary key
   FirstName  Text
   Surname     Text
You also have a form named (say) Form1, and it has a combo named Combo1
which has a RowSource of:
   SELECT ClientID, Surname & ", " & FirstName FROM tblClient ORDER BY
Surname, FirstName;

Now in query design, in the Criteria row under the ClientID field, you can
enter:
   [Forms].[Form1][Combo1]

The report based on that query will then contain only the record for the
person chosen in the combo.

If you already have a form set up that could show the record for the person,
here's another approach:
   Print the record in the form
at:
   http://allenbrowne.com/casu-15.html

Signature

Allen Browne - Microsoft MVP.  Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Hi There.  I have set up a query with a parameter field to print labels
> (full
[quoted text clipped - 5 lines]
> (it would need to show last name, fist name, middle name)... or is this
> getting a bit complicated for a beginner?  Thanks  Len
len - 09 Dec 2005 04:40 GMT
Thanks Allen.  Will check it out.  Greatly appreciate your help.

Regards

Len

> You cannot get a query to give you a combo box.
>
[quoted text clipped - 33 lines]
> > (it would need to show last name, fist name, middle name)... or is this
> > getting a bit complicated for a beginner?  Thanks  Len
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.