Avatar of rowlandwiliams
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?
Microsoft AccessDatabasesVB Script

Avatar of undefined
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.

Cheers,

Christian
ASKER CERTIFIED SOLUTION
PatHartman

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
PatHartman

I got a B for that!!  You are a tough marker.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes