R
ridgerunner
This is part of a longer post I tried to send earlier.
I am building an Access application that resembles a questionnaire or score
card. This is occurring to capture data in a database instead using
individual Excel spreadsheets as is the practice now. I need help with
getting the form to look like the spreadsheet with multiple questions
displayed on the screen at the same time.
I have created a table, DM Checklist, that contains the fields store number,
date, DM category, pt value and question, and score. I have other tables –
DM Category Table, DM Category Comments Table, Sales vs Goals TYD, Store
Numbers Table, tblOverall Comments, tblQst (which contains the questions that
need to be seen on the form, simultaneously. The tblQst contains the fields
DM Category, QstWithPtVal. Tying the store number, date, and DM category
together are important.
I have DM checklist fields that have a look up for the store number and DM
Category fields. Everything worked well while I was creating a report but
when I realized I did not want to make the pt value and question a look up
field, I ran into problems with the form. I cannot determine how to make
more than one question appear on the form, so that it is more like the
spreadsheet they are used to using. I am not very experienced and any help
with this will be greatly appreciated.
I am building an Access application that resembles a questionnaire or score
card. This is occurring to capture data in a database instead using
individual Excel spreadsheets as is the practice now. I need help with
getting the form to look like the spreadsheet with multiple questions
displayed on the screen at the same time.
I have created a table, DM Checklist, that contains the fields store number,
date, DM category, pt value and question, and score. I have other tables –
DM Category Table, DM Category Comments Table, Sales vs Goals TYD, Store
Numbers Table, tblOverall Comments, tblQst (which contains the questions that
need to be seen on the form, simultaneously. The tblQst contains the fields
DM Category, QstWithPtVal. Tying the store number, date, and DM category
together are important.
I have DM checklist fields that have a look up for the store number and DM
Category fields. Everything worked well while I was creating a report but
when I realized I did not want to make the pt value and question a look up
field, I ran into problems with the form. I cannot determine how to make
more than one question appear on the form, so that it is more like the
spreadsheet they are used to using. I am not very experienced and any help
with this will be greatly appreciated.