Form labels based on table in access - Survey database

rowlandwiliams
rowlandwiliams used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
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
Distinguished Expert 2017
Commented:
Here's a sample to get you going.
Questions150907.zip
Distinguished Expert 2017

Commented:
I got a B for that!!  You are a tough marker.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial