Count in combo box

's Computer Specifications

Hi,
I have a form with combo box (combo1)which based on query.
When the form load I would like to count the item in combo1.
If there are no items, the form loading will be canceled and massage "No
items to choose".

Any ideas,

Thanks,
T

's Computer Specifications

The simplest way would be to use a DCount() function to check before you
even open the form.

If DCount("CustID", "Orders", "CustID=123")=0 Then
MsgBox "No Data available for selected filter."
Else: DoCmd.OpenForm "myForm"
End If

--
Bill Mosca, MS Access MVP
http://tech.groups.yahoo.com/group/M..._Professionals

"Tom" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi,
> I have a form with combo box (combo1)which based on query.
> When the form load I would like to count the item in combo1.
> If there are no items, the form loading will be canceled and massage "No
> items to choose".
>
> Any ideas,
>
> Thanks,
> T
>

's Computer Specifications

Thanks.
"Bill Mosca, MS Access MVP" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> The simplest way would be to use a DCount() function to check before you
> even open the form.
>
> If DCount("CustID", "Orders", "CustID=123")=0 Then
> MsgBox "No Data available for selected filter."
> Else: DoCmd.OpenForm "myForm"
> End If
>
> --
> Bill Mosca, MS Access MVP
> http://tech.groups.yahoo.com/group/M..._Professionals
>
>
> "Tom" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Hi,
>> I have a form with combo box (combo1)which based on query.
>> When the form load I would like to count the item in combo1.
>> If there are no items, the form loading will be canceled and massage "No
>> items to choose".
>>
>> Any ideas,
>>
>> Thanks,
>> T
>>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
way to count object in combo box using between dates	Heygrippet	Microsoft Access External Data	1	13th Jan 2009 06:42 AM
combo box count	=?Utf-8?B?Sm9zZSBNLg==?=	Microsoft Excel Misc	1	28th Oct 2006 12:43 AM
combo box count	=?Utf-8?B?Sm9zZSBNLg==?=	Microsoft Excel Misc	0	27th Oct 2006 05:08 PM
Count value in combo box if = to ...	=?Utf-8?B?TWljaGFlbCBTLg==?=	Microsoft Access Reports	2	31st May 2006 04:33 PM
How do I use a query to count records in a combo box?	=?Utf-8?B?QmVuTmVlZEhlbHA=?=	Microsoft Access Queries	1	22nd May 2006 08:54 PM