tempvar update query date field

[raffi]

hello,

i have a query and i have a date field in it, and in the criteria of the date field there's this macro

>=[TempVars]![VarStartDate]

i want to add

<=[tempvars]![VarEndDate] in that criteria

and thats about it

but i dont exactly know how im supposed to do that ....

i want to have

>=[TempVars]![VarStartDate] and <=[tempvars]![VarEndDate] in one criteria

thats basically it ... i just want to merge them together

so in my other form where i have 2 textbox's with one button with temp vars in them so they could update the subform

[June7]

Did you try the expression you posted? It should work.

Or try:

Between [TempVars]![VarStartDate] And [TempVars]![VarEndDate]

[raffi]

ehh ... it worked... i guess i wrote it right and i diden't even experiment it .. i mean i did .. but i had a master child field in the subform and in the master field was empty i had no value in it, and when i did have value in it the dates were set off course so.... umm thx for pointing out the and bit was the answer