DLookup

[neil45156]

Hi Everyone,



Just wondering if anyone can help me with this one.

I am trying to get 2 text boxes to autofill off a DLookup event procedure. As the date changes (driven by system date) I want the 'day' text box to update to the correct day and the 'week' text box to update to the reflect the correct week number.

I understand at the moment that part of my problem is in use of the term 'day' as part of my DLookupas it is undefined?

Any help would be appreciated

Thanks Neil45156

[jzwp11]

I am trying to get 2 text boxes to autofill off a DLookup event procedure. As the date changes (driven by system date) I want the 'day' text box to update to the correct day and the 'week' text box to update to the reflect the correct week number.

I'm not sure what you mean by Dlookup event procedure, are you using the Dlookup() function directly or are you using it in a procedure off some event and if so what event?

Couldn't you just set the default value for the date control to date() to populate it with today's date? For the week number, you can just use the datepart() function to display the weeknumber based on the date. There would be no need to store the weeknumber.