I am using a check box in a schedule form for users to select a week. When submitted, it opens a report and assigns the record source based on the value of a global variable. However, I want the name of a column in the crosstab query to be assigned to a text box. (it would be the first day of the week selected on the form and change if the report closed and reopened with a different week selected). Is there a property or action I could use to assign the value to the text box as the report opens up and the record source comes in?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Assigning text box value in coding
- Thread starter daniec43
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
