Getting Data from Dropdown Lists

L

Lynda

I have a survey form with a number of Form Control Combo Boxes in sheet 1. I
also have a seperate Data sheet where, when the participant answers the
questions on sheet 1, the data will be recorded in the Data sheet. When I
test run the sheets the cell where I have tried to get the data to appear
comes up with #NAME? saying 'the formula contains unrecognised text'. Because
the dropdown is not in a cell I put the dropdown number as the reference that
is obviously why it is saying 'the formula contains unrecognised text'. Can
someone please tell me how I can record the text please.

Cheers
Lynda
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help creating a search form in Access XP 0
Cell data entering slow! 0
Dropdown List 10
Combo Box dropdown data 10
Creating a Chart on form from selected data in query. 0
How to populate other fields when a dropdown was changed 13
Data Source for Dropdown Lists 5
Pictures in dropdown lists 4

Top