Hi all,
My form has a textbox in which I want the user to type a week number, which then brings up a list of records with start and end dates/times within that week in a query subform.
This works perfectly.
However, all I want to happen, is that when the user first opens the form, the textbox defaults to this week's number. I have the expression =Format([Date()],"ww") in the Default Value field for the textbox, but this results in the #Name? error. I can still manually enter the current week number in over the #Name? error and the query runs perfectly.
I feel I am missing something really simple somewhere. I've been up since 3am trying to get this form to work. This is the last thing standing in my way. You are my last hope!