Enter Table/Query value in Form

[Guest]

I have an unbound text box on a form. I have a table with one field only (a
date field) that contains dates every two weeks (pay period ending date). I
want the text box on the form to show the current pay period ending date. I
have the following query SELECT First(Calendar.PeriodEndingDate) AS
EndingDateCurrent
FROM Calendar
WHERE (((Calendar.PeriodEndingDate)>Date()));
How do I get this single value returned by the query to be the default value
for the unbound text box on the form? Also, can the value be obtained on the
form without using the query to filter the value first?

Thanks,

Scott

 

[Guest]

If it is an unbound text box, put this in the Control Source of the text box:

=DLookup("[PeriodEndingDate]", "Calendar", "[PeriodEndingDate] > #" & Date()
& "#")

 

[Guest]

It worked perfect, thank you!

If it is an unbound text box, put this in the Control Source of the text box:

=DLookup("[PeriodEndingDate]", "Calendar", "[PeriodEndingDate] > #" & Date()
& "#")

I have an unbound text box on a form. I have a table with one field only (a
date field) that contains dates every two weeks (pay period ending date). I
want the text box on the form to show the current pay period ending date. I
have the following query SELECT First(Calendar.PeriodEndingDate) AS
EndingDateCurrent
FROM Calendar
WHERE (((Calendar.PeriodEndingDate)>Date()));
How do I get this single value returned by the query to be the default value
for the unbound text box on the form? Also, can the value be obtained on the
form without using the query to filter the value first?

Thanks,

Scott