Help with a between function.

[Viruland]

How do you use a between function as a criteria to open a form?
I have tried this on many ways but is doesn't work.

Dim stCriteria as String
Dim stDateFirst as Date
Dim stDateLast as Date
Dim stFormName as String

stFormName = "Frm_IKA"
stDateFirst = dateDatum1
stDateLast = dateDatum2

stCriteria = Between & " [Date] = #" & stDateFirst & "# And [Date] = #" & stDateLast & "#"

docmd.openForm stFormName,,stCriteria
Live fast, die young and leave a beautiful corpse behind.

 

[MissyEd]

Have you tried:

Dim stCriteria as String
Dim stDateFirst as Date
Dim stDateLast as Date
Dim stFormName as String

stFormName = "Frm_IKA"
stDateFirst = dateDatum1
stDateLast = dateDatum2

stCriteria = "DATE-FIELD-NAME-HERE Between #" & stDateFirst & "# And #" & stDateLast & "#"

docmd.openForm stFormName,,stCriteria

Missy Ed
Looking to exchange ideas and tips on VB and MS Access development as well as office 97 development. Drop me a line: msedbbw@hotmail.com