Hi all,
quick question I just want confirmed (beginner present!) - can you base a form on a query? eg If i make a query with a number of 'questions' can these questions each be added to the form and if so where does the response data go when the user submits this as the form is not bound to a table?
big story short I have a fairly big survey type db I am wanting to make, there is around 250 questions in total, broken up into 8 tables/categories. I was told instead of having a separate question tables for each criteria and a form based off each, I should have one table with a field 'question txt' which contains all questions, and another field being 'section', which i would then assign to each question, however in form design view the form bases the questions off table 'fields', which in the tables are 'question txt', not the questions as they are rows in that table, if that makes sense?!!!
any advice appreciated
Cheers
TB