Write Conflict

[lmcc007]

Check that the control you're trying to assign to doesn't have a calculated Control Source, something begininning with "="

It does not have a calculated Control Source, but I revised the code to txtCompanyTaggedExplanation; it was CompanyTaggedExplanation. Now I get the following error message:

The data has been changed: Error Number: 7878

 

[vbaInet]

What were the exact steps you took to receive that error message? Can it be done in the db you attached?

 

[lmcc007]

What were the exact steps you took to receive that error message? Can it be done in the db you attached?

I hit the check box to tag the item. Went to another record, came back to record, and then hit tag again to untag the record.

I just tried it.

Attach is the db.

 

[vbaInet]

Revise the way you are doing things. Make the form modal so that the user has to close the form before being able to go back to the main form.

OR

Use tabs for this. Put the Explanation field in a different tab

OR

Put it at the bottom of your form and change the Enabled state depending on what the value of the checkbox is.

 

[lmcc007]

Revise the way you are doing things. Make the form modal so that the user has to close the form before being able to go back to the main form.

OR

Use tabs for this. Put the Explanation field in a different tab

OR

Put it at the bottom of your form and change the Enabled state depending on what the value of the checkbox is.

No, that didn't get it. I am trying to delete the data in the field and then close the form and make the label invisible.

I am trying to use this statement to clear the field first before closing:

Forms!fdlgCompanyTaggedExplanation!txtCompanyTaggedExplanation.Value = Null

Do I need to enter something else to accomplish this--remove/delete any data in the field?

 

[vbaInet]

As previously stated, revise the way you're doing things.

Close the form, then set the field to Null. That field also exists in your main form.

 

[vbaInet]

You need a hidden textbox on your main form set to that field to facilitate the process. Refer to the textbox's value.

 

[lmcc007]

You need a hidden textbox on your main form set to that field to facilitate the process. Refer to the textbox's value.

Got it VBA,

I got it to work. I put the WRONG field name down; I should have put "CompanyTaggedExplanation" instead of "CompanyTagged." I can't believe I overlooked that; it took for ever to find that simple misstake.

 

[vbaInet]

It happens to the best of us. I would have thought the field name would work but had to suggest the textbox option instead.

 

[lmcc007]

It happens to the best of us. I would have thought the field name would work but had to suggest the textbox option instead.

I hate when I do that--you feel so stupid--waste a lot of time too.

Anyway, thanks for your help. Also, you teaching me a lot about using forms in different ways--the info in the tables stays put and you use the forms to display it in different ways as long as the PKs are correct.

 

[vbaInet]

You're welcome.

My preferred way of doing what you're doing is to use tabs or hide the Explanation field so everything is on one form.

But if you still want to do it your way, instead of using a bound form, simply use an unbound form and (obviously) an unbound textbox for the second form. On Close, copy the value of the textbox to that field. You wouldn't have to deal with saving records before opening anymore.