A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Main Form with a Subform with Check and Command Boxes



 
 
Thread Tools Display Modes
  #1  
Old April 16th, 2010, 08:39 PM posted to microsoft.public.access.forms
PJ
external usenet poster
 
Posts: 265
Default Main Form with a Subform with Check and Command Boxes

I have a Main Form "FrmSummary Of Deals" that has one unbound combo box with
customer names you can select the row source is based off of a table "tbl
Master Comps". I want to put a check box next to the unbound combo box so
when I select the customer name from the drop down box if I want to I can
select the check box. The subfrom has the details of the customer when you
select that customer from the unbound combo box. When I do put the check box
in and select it for one customer it says checked when I select another
customer. I want to be able to choose different customer. Then I want to
have a command button to select and de-select all customers. Why I want this
check box is I want report to only show the customers I check in the check
box.

Any ideas on how to do this??

Thanks in advance.
  #2  
Old April 16th, 2010, 09:59 PM posted to microsoft.public.access.forms
Jeanette Cunningham
external usenet poster
 
Posts: 2,190
Default Main Form with a Subform with Check and Command Boxes

One solution is to put a yes/no field in the table with the customer names.
This will not work very well if you have a multi-user setup.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"PJ" wrote in message
...
I have a Main Form "FrmSummary Of Deals" that has one unbound combo box
with
customer names you can select the row source is based off of a table "tbl
Master Comps". I want to put a check box next to the unbound combo box so
when I select the customer name from the drop down box if I want to I can
select the check box. The subfrom has the details of the customer when
you
select that customer from the unbound combo box. When I do put the check
box
in and select it for one customer it says checked when I select another
customer. I want to be able to choose different customer. Then I want
to
have a command button to select and de-select all customers. Why I want
this
check box is I want report to only show the customers I check in the check
box.

Any ideas on how to do this??

Thanks in advance.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:42 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.