Form labels based on table in access - Survey database
I am building an access database to record a staff survey. I am in the early stages and have very little knowledge. Currently I have 2 tables - tbl_questions and tbl_responses.
I would like to have a form where the labels contain the questions from the tbl_questions, I will set up a combo box or check boxes for the responses to populate the responses table.
How do I populate the form labels with the questions from tbl_questions?
Microsoft AccessDatabasesVB Script
Last Comment
PatHartman
8/22/2022 - Mon
Bitsqueezer
Hi,
although it would be possible to change the labels according to a text from a table it is very much easier to use textboxes as labels. You can format them like a label (no border, transparent background, locked =true and enabled = false) so the user sees no difference, but you can then simply bound them to the question field of the query where your form is bound to.
although it would be possible to change the labels according to a text from a table it is very much easier to use textboxes as labels. You can format them like a label (no border, transparent background, locked =true and enabled = false) so the user sees no difference, but you can then simply bound them to the question field of the query where your form is bound to.
Cheers,
Christian