Between dates!

[smask]

Hi!

I'm trying to get my form to search between two dates and display all data that lies here.

In my fist nive expression i wrote like this.

With List7
.RowSource = "SELECT * FROM Datum WHERE [Datum] Between #Me.Start# And #Me.Slut#"
End With



Can I do it like this?
Any suggestions?

/ Smask

 

[WayneRyan]

smask,

With List7
.RowSource = "SELECT * FROM Datum WHERE [Datum] Between #Me.Start# And #Me.Slut#"
End With

If the Table's name is Datum and the desired Date Field is
[Datum]. Follow with a .Requery

Wayne

 

[smask]

Hi!

I finaly got it to work.

With List7
.RowSource = "SELECT * FROM Datum WHERE [Datum] Between Forms![Datum]![Start] And Forms![Datum]![Slut]"
.Requery
End With

/ Smask