The results I got were that the filter upon load was the same filter being applied. I put the "" to set the filter to nothing. Did not work. BUT I do have it working. Just has to load and then the filter is reset.
Thanks!
Connie
--- In MS_Access_Professionals@yahoogroups.com, "Duane" <duanehookom@...> wrote:
>
> What results did you get from:
> DoCmd.OpenForm "TrackingSpreadsheet", , "", "LookingID = " & Me.LookingID
>
> I would remove the "" from after the second comma.
>
> Duane Hookom
> MS Access MVP
>
> --- In MS_Access_Professionals@yahoogroups.com, mrsgoudge <no_reply@> wrote:
> >
> > Good morning/afternoon :-) again. I have a filter by form TrackingSpreadsheet that in its load event has a couple of the filter boxes filled. I would like to open that form without the filter and add a where condition. I have tried:
> > DoCmd.OpenForm "TrackingSpreadsheet", , "", "LookingID = " & Me.LookingID
> >
> > Is the only way to do this?
> > DoCmd.OpenForm "TrackingSpreadsheet"
> > Forms!TrackingSpreadsheet.Filter = ""
> > DoCmd.GotoControl LookingID
> > DoCmd.GoToRecord "LookingID = " & Me.LookingID
> >
> > thanks!
> > Connie
> >
>
Tidak ada komentar:
Posting Komentar