Choosing all data or single via combo/list

[AshleyP]

I have form based on a query which picks up data from a
list of contacts, I really need my form to have a list or
combo box where I could choose individual contacts. Does
anyone know of a command button code that would allow me
to do this. Basically choose all or limit to one.

Thanks
Ash

 

[Mark]

Hi,

Please see http://www.mvps.org/access/forms/frm0043.htm

Once you have (All) listed in the combo box you can write code in the After
Update event acordingly.

HTH

--

Cheers
Mark

Free Access/Office Add-Ins at:
http://mphillipson.users.btopenworld.com/

 

[AshleyP]

Any Suggestions on Update code

-----Original Message-----
Hi,

Please see http://www.mvps.org/access/forms/frm0043.htm

Once you have (All) listed in the combo box you can write code in the After
Update event acordingly.

HTH

--

Cheers
Mark

Free Access/Office Add-Ins at:
http://mphillipson.users.btopenworld.com/





.

 

[Mark]

Depending on what you want to do:

If Me.cboComboBoxName.Column(1) = "(All)" Then
'All was selected enter some code here
Else
'Enter code here for a single selection
End IF