DLookUp

[dazoloko via AccessMonster.com]

I have a table which contains information on Audit Periods, the fields being :
-

Financial Year
Period
Period Start Date
Period End Date

What I want to be able to do is from a from when a date is input is to look
up what period that date falls into.

Any Suggestions ?

Cheers

D

 

[RonaldoOneNil]

In this example, the date box on my form is called dtPeriod and this is the
code in the click event of button or the after update event of your date field

MsgBox DLookup("[Period]", "Audit Periods", "[dtPeriod] Between [Period
Start Date] And [Period End Date]")

 

[dazoloko via AccessMonster.com]

Thanks for your response.

Works a treat.

In this example, the date box on my form is called dtPeriod and this is the
code in the click event of button or the after update event of your date field

MsgBox DLookup("[Period]", "Audit Periods", "[dtPeriod] Between [Period
Start Date] And [Period End Date]")

I have a table which contains information on Audit Periods, the fields being :
-

[quoted text clipped - 12 lines]

D