Prev: Lock only updated record
Next: Toolbars in MS Access 2007
From: Dirk Goldgar on 30 Mar 2010 16:55
"hedgracer" <d.christman(a)sbcglobal.net> wrote in message
news:67152cec-cd72-4f80-8184-b66310695b40(a)l36g2000yqb.googlegroups.com...
>
> The drop down on the combobox has the dates formatted exactly like I
> posted them. The data in the Month field in the form's recordsource is the
> same format as the format in the combobox. The data in the combobox is
> from a query in the RowSource property that I posted earlier.

And the recordsource of the form?

> I removed the Form as you stated. Now the row count is okay for 01/31/2010
> (no 02/28/2010 bleeding through) but there is still
01/31/2010 rows bleeding through when 02/28/2010 is selected in the
combobox.

Hmm. That doesn't really make sense to me as being the result of that one
change. You aren't working in an ADP, are you?

After you have assigned to the form's .Filter property based on a combo box
value of "02/28/201", please verify and post the value of the .Filter
property.

Does it make any difference if you change the code to:

Me.FilterOn = False
Me.Filter = "[Month] = '" & Me.cboMthSelection & "'"
Me.FilterOn = True

?

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

First  |  Prev  | 
Pages: 1 2
Prev: Lock only updated record
Next: Toolbars in MS Access 2007