survey filled out no edit allowed

N

nydia

background info:
i have a dba that keeps trak of clients that enter and
leave a program. it contains several tbl's all related by
clientID. all my forms are based on a tbl.

there is a survey that has to be filled out several times
on a client (1 client could have more than 2 surveys
filled out). I have a main form that has a tab control
with several subforms, 1 being the survey.

i want the user to be able to fill out the survey, but
once they finish the survey, i don't want them to be able
to go back and change it. how can i do that?? I have a
date completed field, is there some way of doing it so
that when the date completed field is filled in that that
particular survey becomes viewable only? I still need them
to be able to fill out a new survey, but i want the old
one's filled out to be viewable only.
 

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

Top