Enter or Tab Through Field on Form changes data format?

[syoung7903]

I am going to try to explain this as clearly as possible.

I have two tables.

Table 1 has a field in it I will call Field 1.

Table 2 has the same field I will call Field 2.

I have a form based on table 1. (Of course these tables have lots of other data in them as well).

These tables join on this common field.

Before I open up the form that is based on table 1 if I run a query asking for all the matching data in both tables I have no problem.

Once I open up the form based on table 1 and tab through or enter through the fields on the form and then close the form and go back to the query I get different results.

I do not change data, add data or delete data when I go through the form.

What in the world is going on?

 

[syoung7903]

No it's not row order

it's actually the rows themselves. It's like because I have tabbed through or entered through the fields on the form the joined fields data type changes and after that the joined fields no longer match. I initially populate the tables with an append query. After the append I run the query......all is great. Then I tab through or enter through the same fields on a form and rerun the query and boom.......things don't join anymore. Does this make any sense at all.

Thanks Pat for responding.

 

[The_Doc_Man]

Is there any code underlying the form (class module) that has the power to change data using, say, a LostFocus event routine? I have some cases where I do sanity checking that can recompute some fields. In my case, the changes happen to be relatively benign, but we can't see your case.

Also, I don't know why Tabbing would make a difference, but if you use the Enter key, isn't there a setting that automatically opens that field for editing? And Enter key in that case might blank out the field? Because of that option that I vaguely remember, I might expect different behavior between Tab and Enter. But I have NEVER seen Tab change the contents of a field unless there was some hidden code.