[AccessD] quick help needed

Yeah it sounds a lot better than what I ended up with which has a text
box on top of the second combo box and some requery's in the on
current and after update for the first combo box. I'll have to look at
this tomorrow. This application is one I started working on a year ago
and it's been sitting idle as I've had other bigger fish to fry but
now the intended user has forced me to pick it up again.

Thanks for Sharing David.

GK

On Thu, Jun 17, 2010 at 4:14 PM, Stuart McLachlan
<stuart at lexacorp.com.pg> wrote:
> Damn, that's neat.
>
> Why didn't you post that simple concept years ago on the list.  I could have used variants of it
> lots of times in the past. :-(
>
> --
> Stuart
>
>
> On 17 Jun 2010 at 13:17, David McAfee wrote:
>
>> 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
>> >
>>
>> --
>> 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
>



-- 
Gary Kjos
garykjos at gmail.com