docmd.open form between dates condition

[Ruegen]

I have

DoCmd.OpenForm "frmPaymentsUncompleted", , , "[BookingDate]= between me.txtBeforeDate and me.txtUntilDate"

The form has to unbound text boxes formatted as short date, before and one until - and a button that opens the form to whatever those date values entered are.

I am unsure of how to put in the correct code to make the form work....

frmPaymentsSearchDate is the name of the form that searches the dates.

maybe ?

DoCmd.OpenForm "frmPaymentsUncompleted", , , "BookingDate=" > Me.txtBeforeDate and < me.txtUntilDate

help..

[RuralGuy]

Try:
DoCmd.OpenForm "frmPaymentsUncompleted", , , "BookingDate >= :" & Me.txtBeforeDate & ": and BookingDate <= :" & me.txtUntilDate & ":"

[Ruegen]

Try:
DoCmd.OpenForm "frmPaymentsUncompleted", , , "BookingDate >= :" & Me.txtBeforeDate & ": and BookingDate <= :" & me.txtUntilDate & ":"

thanks will try - why the ":" ?

also it's between dates..

I get this error with the code now

[Ruegen]

The [BookingDate] is the date field in the query of the form that I want to open between the dates of the first form using the text boxes.

I replaced it with

DoCmd.OpenForm "frmPaymentsUncompleted", , , "BookingDate >= #" & Me.txtBeforeDate & "#and BookingDate <= #" & me.txtUntilDate & "#"

[Ruegen]

I am going to say this is resolved unless someone corrects because it seems to work...

[RuralGuy]

You're right, the octothorp "#" is the DateTime delimiter and not the colon ":". My bad!

[Ruegen]

You're right, the octothorp "#" is the DateTime delimiter and not the colon ":". My bad!

no no, it's all good