Bjt
New member
- Local time
- Today, 08:41
- Joined
- Jan 11, 2022
- Messages
- 9
Dear all,
I am going around the forum and google since 2 days, but I am not able to solve my problem, so I post it. I am rather newbie to Access, so please have some patience!
I have a form, on which I input some values using a Combo box and text filed, these input values are then used in a query, by making reference to the form:
[Forms]![Extract_Timeliness_data]![txtMonth]
[Forms]![Extract_Timeliness_data]![cmbTeam]
and so on.
After the query I create a report using query's result.
In this report I would have to have dynamic generated label caption, e.g.:
Months: value of [Forms]![Extract_Timeliness_data]![txtMonth]
Team: value of [Forms]![Extract_Timeliness_data]![cmbTeam]
It sounds to me trivial, but apparently it is not.
I did not use SQL but simply the design tools of Access.
Any suggestion is welcome.
Thank you, I.
I am going around the forum and google since 2 days, but I am not able to solve my problem, so I post it. I am rather newbie to Access, so please have some patience!
I have a form, on which I input some values using a Combo box and text filed, these input values are then used in a query, by making reference to the form:
[Forms]![Extract_Timeliness_data]![txtMonth]
[Forms]![Extract_Timeliness_data]![cmbTeam]
and so on.
After the query I create a report using query's result.
In this report I would have to have dynamic generated label caption, e.g.:
Months: value of [Forms]![Extract_Timeliness_data]![txtMonth]
Team: value of [Forms]![Extract_Timeliness_data]![cmbTeam]
It sounds to me trivial, but apparently it is not.
I did not use SQL but simply the design tools of Access.
Any suggestion is welcome.
Thank you, I.