T
thesofa
Guest
Hi,
Can you please help me to use the value from one of 5 fields in a table of only one record, as the default value in either a field in a different table or as the default value in a control on a subform in a form.
The values I need to use are in short date format and they are the date values for the 5 weekdays of the preceding week. These are set by inputing the last day of the previous week via a parameter query through a form.
This value is then used in an update query in a table called "Week"
(imaginative names abound here)
The other fields are Mon, Tue, Wed, Thu, and Fri, each containing the date for the day.
The next week the data is replaced with the new dates.
I then need to use the value from the fields Mon to Fri as the default value in the Mon to Fri subforms.
How can I do this please.
TIA
thesofa
Can you please help me to use the value from one of 5 fields in a table of only one record, as the default value in either a field in a different table or as the default value in a control on a subform in a form.
The values I need to use are in short date format and they are the date values for the 5 weekdays of the preceding week. These are set by inputing the last day of the previous week via a parameter query through a form.
This value is then used in an update query in a table called "Week"
(imaginative names abound here)
The other fields are Mon, Tue, Wed, Thu, and Fri, each containing the date for the day.
The next week the data is replaced with the new dates.
I then need to use the value from the fields Mon to Fri as the default value in the Mon to Fri subforms.
How can I do this please.
TIA
thesofa