[AccessD] quick help needed

Gary, IIRC, one thing I did before in regards to cascading comboboxes
in a continuous form (wow, a tongue twister) was
to have two different rowsources for the 2nd combo box.

The normal, or OnCurrent combo would list everything (not really cascading) and
in the 2nd combo's OnEnter event I change the rowsource to reflect
that of the first.
The OnChange event would change it back to the "everything"

something like this:
OnEnter:
Me.SecondComo.Rowsource = "EXEC stpShowFilteredDate " & NZ(Me.FirstCombo,0)

OnChange:
Me.SecondComo.Rowsource = "EXEC stpShowAllData"



On Thu, Jun 17, 2010 at 12:59 PM, Gary Kjos <garykjos at gmail.com> wrote:
> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>