How to reference a date field in a query 3

[Pampers]

Hi everyone,
I want my query to reference a date value on a form, but I cant get it right. I tried this, but no good:

"#" & [Forms]![frmInvoice]![frmInvoiceSub1].[Form]![InvoicePeriodFrom] & "#"

Any ideas?

Pampers
Keeping it simple can be complicated

 

[TheAceMan1]

Howdy pampers . . .

[blue][Forms]![frmInvoice]![frmInvoiceSub1].[Form]![InvoicePeriodFrom][/blue]

See Ya! . . . . . .

 

[Pampers]

Hi TheAceman1
I tried that too, but it didn't work.

Pampers
Keeping it simple can be complicated

 

[rjoubert]

[Forms]![frmInvoice]![frmInvoiceSub1].[InvoicePeriodFrom]

 

[rjoubert]

Or...

"#" & [Forms]![frmInvoice]![frmInvoiceSub1].Controls("InvoicePeriodFrom").Value & "#

 

[TheAceMan1]

Roger That pampers . . . and:

[blue]"#" & Format([Forms]![frmInvoice]![frmInvoiceSub1].[Form]![InvoicePeriodFrom],"m/d/yy") & "#"[/blue]

See Ya! . . . . . .

 

[Pampers]

Tnx for the replies all,
I'm gonna try it tommorow at work. I keep you posted.

Pampers
Keeping it simple can be complicated

 

[Pampers]

Hi there,
Tnx for all the suggestions. I did some modifications on the design, and now the straight way of refering works. This is what I put in the criterium field of the query (append query)

>=[Forms]![frmInvoice]![InvoiceRunFrom] And <=[Forms]![frmInvoice]![InvoiceRunUntill]

Pampers
Keeping it simple can be complicated

 

[TheWildHare]

You could have also used "Between #" & [forms]![frmInvoice]![InvoiceRunFrom] & "# and #" [forms]![frmInvoice]![InvoiceRunUntil] & "#"

Which would translate at runtime to:

Between #10/1/06# and #10/31/06#

Just another way to skin 'er....

 

[Pampers]

Tnx TheWildHare, so thats the way that works . Is was thinking about it, but then avoided it.

Pampers
Keeping it simple can be complicated