The Source of a combo keeps getting changed by itself ???

[matrekz42]

Good morning Guru's

I have a form that has a combo box and the source of a combo keeps getting changed by itself.

I haven't found the pattern if it happens after compact and repair or after debug. But the criteria of the source changes to sort by same item in another form.

The entry form is meant to sort by [form]![Entryform]![cbo_file] and it automatically changes to [form]![Auditorform]![cbo_file]

The Control Source is a query.

Im clueless, any guesses?

[puppydogbuddy]

Good morning Guru's

I have a form that has a combo box and the source of a combo keeps getting changed by itself.

I haven't found the pattern if it happens after compact and repair or after debug. But the criteria of the source changes to sort by same item in another form.

The entry form is meant to sort by [form]![Entryform]![cbo_file] and it automatically changes to [form]![Auditorform]![cbo_file]

The Control Source is a query.

Im clueless, any guesses?

The syntax is not correct....so it could cause Access's response to be unpredictable. Have you been compiling your code? I don't understand why you did not get a compile error.

Change>>>>> [form]![Entryform]![cbo_file]
To>>>>>>>>> [Forms]![Entryform]![cbo_file]

Let us know if that fixed the problem.

[NeoPa]

I can't see how either is even possible.
What would [form]![Anything] resolve to?
Is it possible that you've posted without copy/pasting?

[matrekz42]

OK, I figured it out. The problem was... Drum roll please...

The Mysysqueries would keep in memory that I saved as a form and was reseting every object's source back to what it was before

So I fixed it, but thanks for all your help.