Prev: Access 2007-Duplicate Record Field Capability
Next: MS Access Themes not displaying on some Computers
From: PJ on 16 Apr 2010 15:39
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.
From: Jeanette Cunningham on 16 Apr 2010 16:59
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" <PJ(a)discussions.microsoft.com> wrote in message
news:6A2C82A0-6F02-419F-A7E6-341C08832A13(a)microsoft.com...
>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.


 | 
Pages: 1
Prev: Access 2007-Duplicate Record Field Capability
Next: MS Access Themes not displaying on some Computers