[AccessD] quick help needed

That's what we are here for. ;-)  Glad you got it figured out.

I'm actually working on an Access Development project right now. First
time in YEARS. Strugling through cascading combo boxes on a continuous
subform. Grrr. I think I have it now. With some magic putting text
booxes on top of combo boxes and "On Current Requery" code.

GK.

On Thu, Jun 17, 2010 at 1:19 PM, John Clark
<John.Clark at niagaracounty.com> wrote:
> Sorry...I guess more info would be in order...I'm just sweatin' a little over this.
>
> The record source for this report is a query ("qryCertInfo"). This query is based on two other queries...the first being a table of "county information" ("qryCntyInfo") and the 2nd ("qryCert2Print") which is based off the current record that is up on the entry form. This form based query chooses its single record from "[Forms]![frmDataEntry]![ssn]" on the form, and, "[forms]![frmDataEntry]![sfrmCerts].[Form]![Certificate Date]" on that form's sub-form.
>
> As I am typing this, I'm wondering if I may not have found my own solution...might it be because there is yet to be any data on the subform? There is nothing in, "[forms]![frmDataEntry]![sfrmCerts].[Form]![Certificate Date]", so maybe it is fudgin' up things.
>
> BUT...why does it work sometimes? If this is the case, it shouldn't work at all.
>
> ...NEVERMIND...I found it! It IS what I just described. For some reason, she was forgetting to enter a certification date, and the program was choking on that. So, I showed her what the problem was...and now I have to add something to check for this.
>
> Thanks for the help...sometimes I just need to talk it out w/someone. It tends to scare those around me, w/I talk amongst myself ;o)



-- 
Gary Kjos
garykjos at gmail.com