[AccessD] When a query refers to a control on a form whichisnot open - how to supply a default?

Hi Dave, welcome to the party. The query is the recordsource of a subform
existing on a form which contains a partial view of information the user has
already entered on a dictator form. They enter their information on the
latter's interface, click a button to launch the new form (which has several
subforms); when they get to the newly opened form, the subform in question
is supposed to have as its recordsource the query in question, whose results
are limited by the first form. Seems pretty standard to me?


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David McAfee
Sent: Wednesday, June 02, 2010 2:09 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] When a query refers to a control on a form whichisnot
open - how to supply a default?

Let me think out of the box for a bit.

Where is this query being called from?

Usually when I call a query that refers to a form, it is called from
the form being referred to.

If this is the case, you can check if the if the field is blank before
you call the query.

something like

if nz(me.RecordID,0) = 0 then
     'Call query or report without the reference to this form
Else
     'call existing query which references this form
end if



On Wed, Jun 2, 2010 at 10:47 AM, Bill Benson (vbacreations)
<vbacreations at gmail.com> wrote:
> Doug, not sure how to implement this? The query is "out there" as an
object
> in the database; it is used as a recordsource for a subform ... how am I
> supposed to let code control it? I am not using any code?
>
> On the other hand if what you mean is that I should set a parameter equal
to
> a function which code I have controlled - well that is the same thing as
> others are suggesting.
>
> My choice appears to be VBA or VBA or VBA ... rather than VBA or more
> flexible SQL...?
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele
> Sent: Wednesday, June 02, 2010 10:11 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] When a query refers to a control on a form which
> isnot open - how to supply a default?
>
> Change the query to a parameter query; then your code controls the value
> that is passed to the query.
>
> Doug
>
> On Tue, Jun 1, 2010 at 3:43 PM, Bill Benson (vbacreations) <
> vbacreations at gmail.com> wrote:
>
>> SELECT TblCIB.RecordID, TblCIB.ShopOrder, TblCIB.ItemNumber FROM TblCIB
>> WHERE
(((TblCIB.RecordID)=[Forms]![frmExciterIndividualEntry]![RecordID]))
>>
>> The above sql is causing the user to be prompted for a value of
>> [Forms]![frmExciterIndividualEntry]![RecordID] when that form is not open
>> and/or the control not populated. I would like that when there is no form
>> or
>> control available at runtime, the query just assumes a 0 or "" [default]
> so
>> that my users are not prompted. Is there some simple [single expression]
>> way
>> to do this short of the workaround I show below, which seems like
>> overkill??
>>
>>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 9.0.819 / Virus Database: 271.1.1/2912 - Release Date: 06/02/10
> 02:25:00
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
No virus found in this incoming message.
Checked by AVG - www.avg.com 
Version: 9.0.819 / Virus Database: 271.1.1/2912 - Release Date: 06/02/10
02:25:00