date stamp

[Nydia]

I'm trying to create a database that keeps track of our
clients.

What I need help on is a questionaire that is filled out
by am employee about a client. There is about 25 question
and the same questions are asked 4 different times (2
months after start date, 4months later, 6 months later
etc). Start date is in another table. Right now, I have
the table set up with the following fields

clientID
Term (there are 4 terms, term 1= 2 months after start date
term 2=4months later etc)
date completed
q1
q2
q3
etc, etc
comments.

what i want is when the employee finishes all the
questions and comments for a date to automatically fill in
the date completed field, and for the employee not to be
able to change that date. how can this be accomplished
and does the table structure look ok.

any help is greatly appreciated.

 

[Charlie Harcum]

I would have a button at the end of the questionare that they have to click on that says "finish" or "save" or something like that. Behind the button, i mean the code that runs behind it, you can put something to the effect of

[date completed] = now()

you may search the help files for the now() function, but I believe this is correct. that will insert the current date(and time) into the date completed field.

As far as locking the field, you should be able to view the properties for that particular field on the form and there are a few properties in there you can use, i think one is called "locked". you can simple enable this and they will not be able to change the date. you could also make it invisible to the users.

Charlie Harcum
MCP