Fields deleting by themselves

[JKool]

Hi all, I'm new here and I have a feeling I'm going to learn a lot. Anyways, I have a question....



In the database I'm using, we have two fields on the main user form (well, there are more than two fields but these are the two I'm focused on). They both allow text. When I finish typing in both, the text dissappears when I click on another field. Also, if I just type in one of the two fields and click on another field (outside of the two), the data in one gets copied (or appears) in the other.

There is something wrong with these two fields but I can't figure out what. I'm not able to put the data I want in both (it either gets copied from one to the other without me doing anything, or they both get deleted - without me doing anything at all. What could be the cause of this?

I appreciate any and all help/suggestions. I went through it and matched it all up and it looks ok.

Thanks!

J-

[Dal Jeanis]

1) For each field, check the event code (in form view, right click on the field, open the properties pane, events tab, see if any of them say "procedure". If so, check the code behind them.

2) Also for each field, check the data tab, and see what each field is bound to. Is it an expression, a variable, or what? Also check the default value while you are there.

If either of these tests solves your problem, please tell us what it was and mark the thread solved. If not, please give an extremely specific description of each field, including the results of the above two tests, and what behavior you are experiencing, and we'll give you some more things to look at. (The errant behavior may be based upon code in the form itself, or validation routines, or several other things.)

[JKool]

It worked! Thank you soooo much. The data tab, it was linked to the wrong source (they both were). I appreciate your help!! I can't see how to mark this solved from here but I'll try to do it once I post this.

[Dal Jeanis]

You're quite welcome. That was the way to bet, but there are a lot of interacting things that it also could have been. Glad to help.

[Dal Jeanis]

Top of the thread, third from the right (Thread tools), mark this thread as solved. Anyone can do it, but I think it's more satisfying when you get to mark it yourself.