424,303 Members | 1,339 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,303 IT Pros & Developers. It's quick & easy.

Y/N Check box to disable or enable entry to a feild

P: 15
I have a field name NA, it is a yes/ No field. I want that when the I check Yes to this NA column, the field "Scores" is disable so people can't enter the score for that record if the question is not applicable.
Sep 26 '14 #1
Share this Question
Share on Google+
5 Replies


zmbd
Expert Mod 5K+
P: 5,285
Kaylen83,
Only in ACC2010 and newer is this possible at the table level and requires the use of a data-macro. It's usually not best practice to allow users to enter data at the table level, let alone let them see the tables.

All other versions of ACC would require a Form and either a Macro or VBA code to provide the logic behind allowing data entry which can be achieved in various ways.

You have provided precious little information to work with concerning the version of Access, table design, form design, etc... also it would be helpful to know how experienced you are in database design and your experience level with Access in general.

In my typical DBA design, the user wouldn't even see the record of a non-relevant question; thus, there would never be an opportunity to enter the score.[*]> Database Normalization and Table Structures.

Keep in mind, NA is very close to a reserved Keyword and may cause you issues. Please consider changing it:
Access 2007 reserved words and symbols
AllenBrowne- Problem names and reserved words in Access
Sep 26 '14 #2

P: 15
Thank you. Is there a way to display a blank list of questionaire for every new record. And the person to answer only the applicable questions. I am thinking then to apprend those answers to the historical table where all the answers are kept? Any advice on how to get this structure done?
Sep 26 '14 #3

zmbd
Expert Mod 5K+
P: 5,285
Kaylen83,
(^_^)
Please one question per thread.

Simple answer would be, there are many ways of doing what you ask. Anything more detailed will require a new thread and MUCH more detail about version of Access/Office, your database table design, etc...
Sep 27 '14 #4

Rabbit
Expert Mod 10K+
P: 12,303
I believe this is the same question but phrased differently?
Sep 27 '14 #5

zmbd
Expert Mod 5K+
P: 5,285
Rabbit, the way I read it posts are:

OP: Control/Field-1 to toggle input state of Control/Field-2

Post#3: How to append records to another table so that that the end-user only views the applicable records; basically, how would one achieve Post#2-Paragraph-4.
Sep 29 '14 #6

Post your reply

Sign in to post your reply or Sign up for a free account.