How to use a Day from a Specified Date in a query

[WickidWe]

Hi,

I have a form that will be used for rostering, It has cascading text and combo boxes to a final outcome of options based on the previous boxes.


I have put a Text box which is set to the "Short Date" Format. What I need is a text box that can be used to display the Day of the specified Date that can also be used in a query further down the list.

Please include any VBA code that may be required Thanks

Dan.

[Bob Fitz]

I think you need the WeekdayName() function.

[WickidWe]

thanks for the reply, I am new to access so forgive my asking.
where do I place this?
I need to refer to the text box where the date is selected which I Named txtDate
the box that I want the Day to be Displayed is called txtDay.
Also I want to put an "After Update" requery on the txtDate to update the day. Do I need to put an "After Update" requery on the txtDay as well to be used in a later query?

[Bob Fitz]

Try this:
Put:
= WeekdayName(Weekday([txtDate],2))
as the Control Source property of the text box that is to be used to show the day.

[WickidWe]

Thanks this did it, now I have the textbox showing the Day Name.
Am I able to requery somehow when I change the date in another text box Have tried the following but it is
not updating the day. I reallize "= WeekdayName(Weekday([txtDate],2))" is not a query but am usure how to get it to update.

Private Sub txtDate_AfterUpdate()
Me.txtDay.Requery
End Sub

It only updates when I reopen the form

[WickidWe]

I have it sorted thank you.

It is updating once i have clicked in another box.

[orange]

Dan,

For Access functions and sample usage keep this for reference.

Good luck.

[Bob Fitz]

I have it sorted thank you.

It is updating once i have clicked in another box.

That's because the Update event fires when the focus leaves that control.