Why is this section of the form dirty

[Lou_Reed]

In the following file which I have attached and uploaded the form is now a combination of two forms. The two are AddPersonal Form added to Personal Form.

You can see the AddPersonal Form by itself by just clicking on it in the Navigation window.

Now what I am confused about is if you open the AddPersonal Form by itself, all the entries First Name, Last Name, Preferred, are empty they are not dirty. They contain nothing no names. This is as it should be.

However. when you open the Personal Form which now has the AddPersonal Form included at the top it does contain names, they are dirty, namely one name from the employees list or the last employee added.

This is not as it should be. I want the first name, last name, and preferred name spaces to be empty as it was in the AddPersonal Form.

What is causing this and how do I fix it?

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[ranman256]

I find the IsDirty functions useless and quit using them long ago.

[Lou_Reed]

Okay, but as you can see in Personnel Form (opened by itself) the first name, last name, and preferred name are empty. It is like their contents have been transferred to the list of active personnel list down in the form below.

However, when I add the AddPersonnel Form to the Personnel Form and open this form in form view the contents of each of these three boxes is still shown, say Soupy Sale, Soupy. It not empty as shown in the AddPersonnel box when opened by itself.

My goal here is to have those three boxes in the new Personnel form to be empty. I just cannot see how to do that.

That is my question. It looks rough, tacky, and unprofessional to have those boxes showing past added name whenever this modified Personnel form is opened.

How do I get rid of them?

Any help appreciated. Thanks in advance.


Respectfully,


Lou Reed

[John_G]

Lou -
Your database uses linked tables which you did not provide, so it is impossible to open the forms to see what you are referring to.

[John_G]

Your frmPersonnel has several cases where you have two text box controls with the same control source, (e.g. LastName and FirstName), so they are referring to the same field in the form's underlying table or query. When you do that, both textboxes will always show the same value (for the current record). When two textboxes are bound to the same table field, you cannot have one blank and the other not - it's just not possible (and wouldn't make sense, anyway).