DoCmd Criteria

[traceytr]

Hi. I'm new to VBA, and I cannot find the answer to the following puzzle. When I run this code, I'm prompted to enter MyDate and Today. (No wrappiing in my DoCmd line.) Why does it not use the dates assigned to the variables? Thanks. Tracey


MyDate = (Date - 60)
Today = (Date + 1)

DoCmd.OpenForm "frmLPL", acNormal, , "[FaxReceived] BETWEEN MyDate and Today", acFormEdit, acWindowNormal

 

[TheAceMan1]

How are ya traceytr . . .

. . . and this:

[blue]   Dim Criteria As String
   
   MyDate = (Date - 60)
   Today = (Date + 1)
   Criteria = "[FaxReceived] BETWEEN #" & MyDate & "# AND #" & Today & "#"
    
    DoCmd.OpenForm "frmLPL", acNormal, , Criteria, acFormEdit, acWindowNormal[/blue]

See Ya! . . . . . .

 

[traceytr]

Thanks! Worked like a charm.