Unique Text Box

[despatcher]

Just when i thought the db was finished i decided to let the boss check it.

What we have.

An Employee Database that has employee qualifications that each have a specific run out date. I fill in the database with all correct information the bos checks the db and wants to be able to do the following:

Open up forms as usual cycle through each employee (114) form and be able to write a specific message regarding that employee on that employees form.

Simple i said so i did the following:

On the form i have placed a text box.

THE FLAW

He writes something in the box and it appears on all the forms. WHY?

Not an Insult just my favorite saying!

Keep It Simple Stupid KISS

 

[pbaldy]

My guess is that the textbox is not bound to a field in the table.

 

[despatcher]

does it need to be ?

i want it independent of everything itis purely for his own comments so when he prints off an mployees profile he can read his own review nots

 

[ghudson]

If the text box is not bound to a field in a table then you will not be able to store [save] his comments for the selected record. Kinda defeats the purpose of what you want if it is not bound.

 

[pbaldy]

What he said.

If you don't want this to be a field in the main employee table, you could have a "BossComments" table, that had a field for employee number (to relate back to the main table) and a comments field. The 2 tables could be joined for this form.