Link to home
Start Free TrialLog in
Avatar of rowlandwiliams

asked on

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?
Avatar of Bitsqueezer
Flag of Germany image


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.


Avatar of PatHartman
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I got a B for that!!  You are a tough marker.