zufie wrote:
> I can't figure out how a re****t on a form (form contains two text
> boxes for beginning and end dates of re****t) and a drop down combo box
> also on the same form (that allows for selection of county) are
> connected to produce a re****t sorted by county?
>
> I seek, but do not find how this works.
>
> Grateful for any ideas you may have.
>
> Zuf
>
I'd add a command button to display the re****t.
Then I might have code similar to:
Dim strF As String
If Not IsNull(Me.FromDate) Then
strF = "TableDateFld >= #" & Me.FromDate & "# And "
Endif
If Not IsNull(Me.To) Then
strF = strF & _
"TableDateFld <= #" & Me.ToDate & "# And "
Endif
If Not IsNull(Me.ComboBoxName) Then
strF = strF & _
"TableDateCntry = '" & Me.ComboBoxName & "' And "
Endif
'remove the 'And' at the end
If strF <> "" THen strF Left(strF,len(strF)-5)
Docmd.OpenRe****t "Re****tName",,,strF
In the above example I permit records greater date, less than date or
within date range.
As far as sorting it, open re****t in design mode and select
View/Sorting&Grouping from the menu.
Simple
http://www.youtube.com/watch?v=mqXVghIWuws&NR=1
|
