Prev: Should I completely abandon Requery?
Next: opening form to specific data
From: Daniel Habtemariam on 20 Apr 2010 06:40
Did the trick. Thanks Tom.

On Apr 19, 8:46 am, Tom van Stiphout <tom7744.no.s...(a)cox.net> wrote:
> On Mon, 19 Apr 2010 06:39:13 -0700 (PDT), Daniel Habtemariam
>
> <dhabt...(a)gmail.com> wrote:
>
> Check out the DCount function. Your parameter goes in the
> where-clause:
> intCount = DCount("myField", "myQuery", "CustomerID=" & Me.CustomerID)
>
> In many cases the alternative is to provide a dropdown with available
> choices.
>
> -Tom.
> Microsoft Access MVP
>
>
>
> >Hi all--I know there's gotta be a simple answer to this...
>
> >I need to run a query, and depending on the results of the query, a
> >variable called Eligible should be set to either 0 or 1.
>
> >If there are no records returned, then the variable, Elligible, must
> >be set to 0; if there are one or more records returned, then Eligible
> >= 1.
>
> >Simple, right?
>
> >Other pertinent information:  The query is a simple parameter query.
> >This is all in the context of VBA code on a form.  The overall
> >objective is authenticate a data entry value on the form by looking up
> >whatever was entered against a table of acceptable values for that
> >variable.
>
> >Thanks in advance.

 | 
Pages: 1
Prev: Should I completely abandon Requery?
Next: opening form to specific data