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 / Forms / March 2008

Tip: Looking for answers? Try searching our database.

how to select record that you want to print in query criteria

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Marco - 17 Mar 2008 17:30 GMT
Hi. I need to build a form the has some options to make wich will after the
filter/criteria for queries.

my olnly question is that I have to build something that will allow me to
from a list of deprtments wich one I want to print.

I have a table with all departments. Now I wanted to have a list or grade on
my form that would allow me to choose two department of 10.

I start to create a subform in continuous form with all results from the
department table. then I insert a check box in the detail option but any time
ti choose a department by clicking the check box all departments were
selected.

I can I solve this? How can I have the possibility choosing what departments
I want to select?

Regards,
Marco
Clif McIrvin - 17 Mar 2008 19:20 GMT
<snip>

> I can I solve this? How can I have the possibility choosing what departments
> I want to select?

Can you use a combo box instead of sub-form?  I use combo-boxes
frequently to select one member of a group from one of my tables.

Add an unbound Combo Box to your form and set the row source to a
query that generates the list of choices for you.

Using this method requires code to manipulate the filters.

--
Clif
 
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.