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?
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?
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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.
Cheers,
Christian
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
Premium Content
You need an Expert Office subscription to comment.Start Free Trial