Yes each routine is in it's own sub. I just didn't include the "end Sub". I've pasted your code as you suggested with the same results. As far as nulls are concerned, I don't understand the possibility of that since the only choices available for the criteria come from records within the data. -- Thanks for your help! Walter "Steve" wrote: Hi Walter, It's hard to

Yes appears to be combo2 is populating correctly. Here is the code: Combo1;set rowsource for combo2 Private Sub SearchType_AfterUpdate() Select Case [SearchType] Case "Origin State" Me.Criteria.RowSource = _ "SELECT Distinct [tblLoadDetails].[OriginState], [tblLoadDetails].[OriginState]" & _ "FROM [tblLoadDetails];"

On Feb 15, 3:05 pm, Nick...@Click.com wrote: On Fri, 15 Feb 2008 13:44:06 -0800 (PST), pyjamarama <pyjamaram...@yahoo.com> wrote: Have you cited where "people should have their kneecaps broken" lately, BONDE? I've cited where YOU said Katherine Harris "Should be at least shot" ] No, I said all NAZIS should be shot Noooooooo.... YOU SAID: "She should be at least

"lame soiled barfly" deleted and bleated the usual right-wing tripe: Kurt Lochner restored the origincal text.context deleted by: "lame soiled barfly" whimpered the usual childish right-wing epithet: Kurt Lochner pointed out yet another fallacy argument from: "gummer" <dumber@takespeed.nut> wrote: Kurt Lochner pointed out the fallacy