Datasheet Subform

[edwardm608]

I have a form and a datasheet subform in Access. A form has person info and datasheet subform has 4 fields: QuestionID, QuestionNumber, QuestionName and Answer fields. The Answer field is a dropdown field and has 3 items: Yes, No and N/A. If QuestionNumber from 3 to 6 the answer was Yes or No then lock the Answer field in Question 7. Any idea how to do it?

 

[SamDeMan]

i think you need help with a survey. i found an interesting toturial and i don't think it is easy to implement, but it may give you some good ideas.
go to:
http://www.rogersaccesslibrary.com/OtherLibraries.asp
and on this page there is a guy by the name: Hookom, Duane
download a full featured example of his At Your Survey 2000 (354 KB) Access 2000

good luck,

sam