The other day, you gave me a fantastic fix for resetting my form
recordsource. You told me to add the query statement in second column of the
combo for each user selection in the first column. That works fantastic!!!
But now my filter doesn't work. I know I probably have something in the wrong
order. I have tried:
me.recordsource = me.cbodatasource.column(1) & vbnullstring
me.filter = "[district] = """ & me.cbodatasource & """"
me.filteron = true
me.requery
me.filter= "district] = """ & me.cbodatasource & """"
me.filteron = true
me.recordsource = me.cbodatasource.column(1) & vbnullstring
and all other combinations. I have tried requeries after one statement,
requeries after both. It will filter or it will set recordsource but not
both. I hope I won't have to have a separate combo for that. Thanks so much!
Milton
--
Milton Purdy
ACCESS
State of Arkansas
|
|
0
|
|
|
|
Reply
|
 Utf
|
5/6/2010 7:06:01 PM |
|
Dirk - I was having a brain fart. I removed the filter and put the
Forms![myform].mycombo as the criteria of the other query. Worked like a
charm! Thanks so much again!!!!! Milt
--
Milton Purdy
ACCESS
State of Arkansas
"golfinray" wrote:
> The other day, you gave me a fantastic fix for resetting my form
> recordsource. You told me to add the query statement in second column of the
> combo for each user selection in the first column. That works fantastic!!!
> But now my filter doesn't work. I know I probably have something in the wrong
> order. I have tried:
> me.recordsource = me.cbodatasource.column(1) & vbnullstring
> me.filter = "[district] = """ & me.cbodatasource & """"
> me.filteron = true
> me.requery
>
> me.filter= "district] = """ & me.cbodatasource & """"
> me.filteron = true
> me.recordsource = me.cbodatasource.column(1) & vbnullstring
>
> and all other combinations. I have tried requeries after one statement,
> requeries after both. It will filter or it will set recordsource but not
> both. I hope I won't have to have a separate combo for that. Thanks so much!
> Milton
> --
> Milton Purdy
> ACCESS
> State of Arkansas
|
|
|
0
|
|
|
|
Reply
|
Utf
|
5/6/2010 7:22:02 PM
|
|
"golfinray" <golfinray@discussions.microsoft.com> wrote in message
news:2C8A77D5-05C0-4CC3-8004-EC1085C8A34A@microsoft.com...
> Dirk - I was having a brain fart. I removed the filter and put the
> Forms![myform].mycombo as the criteria of the other query. Worked like a
> charm! Thanks so much again!!!!! Milt
Glad you got it working, Milt.
--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html
(please reply to the newsgroup)
|
|
|
0
|
|
|
|
Reply
|
Dirk
|
5/6/2010 7:24:14 PM
|
|
|
2 Replies
222 Views
(page loaded in 0.062 seconds)
Similiar Articles: Design View Disabled? Please Help!! - microsoft.public.access ...LOL I've had to deal with users like that. -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please ... Please Help!! - microsoft.public.access ..... standard menu ... Simple function giging me a syntax error, please help! - microsoft ...- >>>> Tremors II >>>> "Dirk Goldgar" <dg@NOdataSPAMgnostics.com> wrote in message ... NZ Function -- PLEASE HELP!! - microsoft.public.access Please help me i stuck in this ... dbnull int32 -please help - microsoft.public.dotnet.framework ...If it's bound to some other type of field, an Integer ... -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please ... Thanks for help Morris ... me.check15) returns ... help with Where clause - microsoft.public.access.formscoding ...Thanks for your help! With Me .OrderDate ... You should change one or the other. -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the ... Help Please - microsoft.public.access-- Dirk Goldgar, MS Access MVP Access tips: www.datagnostics.com/tips.html (please ... Help Please is currently revamping its business strategy and will be back online at ... Reference Form Field through a Module - microsoft.public.access ...... invalid qualifier" when i tried this. Stil can't get it to work. Help please.... ... 11:56 am, sandog <Sandon...@gmail.com> wrote: > On Feb 1, 10:56 am, "Dirk Goldgar ... method or data member not found - microsoft.public.access ...... to select it I got the following message: "Name conflicts with existing module, project, or object library" Please help!!! Thanks in advance! Dwight "Dirk Goldgar ... When hover my mouse , I want a pop-up tip box - microsoft.public ...You could even have a "help" popup form that remains open ... of your solution in the first place, Stephen. -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please ... microsoft.public.access.forms - page 24Dirk Goldgar help please!!! Utf 2 120 The other day, you gave me a fantastic fix for resetting my form recordsource. You told me to add the query statement in second column ... Exclude a field from WHERE clause, if null - microsoft.public ...Hi all, I'm new to access - sorry, will you help ? I ... WHERE SomeField Is Null OR SomeField = '' -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply ... PLEASE HELP:Type Mismatch Error: Set doc=wdApp.Documents.Open(fDia ...See the example in the online help. -- Dirk Goldgar, MS Access MVP Access tips: www.datagnostics.com/tips.html (please reply to the newsgroup) Re: Need Help on TableDefRe: Need Help on TableDef ... Let's see the code you're using, please. Also, is this a linked table or a local table? -- Dirk Goldgar, MS Access ... Bucks County Academy of Fencing — Lambertville, NJ & Hatfield, PA... is here to answer questions, help with equipment ordering, keep track of class payments and schedules, etc. ... DIRK GOLDGAR: MONITEUR (INSTRUCTOR) Dirk Goldgar ... Help with Me.DirtyPlease help me understand the above snippet of code assuming a single form. ... Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) If No Records in Subform, Parent Form Record doesn't display DataBaseThanks for the help! -- Thanks. ... main form's recordsource query. -- Dirk Goldgar, MS Access MVP Access tips: www.datagnostics.com/tips.html (please ... 7/29/2012 7:58:22 PM
|
Search |
Post Question |
Groups |
Stream |
About |
Register
38 followers. 