Access automatically changes name of form in conditional query

I have a list box on a form that has information that changes based off of a
field on my form.

For example, in a text box if I put "RED", the list box shows me all flowers
that are red. If I put "Yellow", the list box updates and shows me all that
are yellow.

In the query, for flower type, I have the criteria look like this...

=Forms!frmflowers!txtcolor

At the discretion of Access, everytime I jump out of design view and try to
view the page, it changes the criteria to:

=Forms!frm1!txtcolor

I don't know where frm1 is or why it keeps changing, but I have to keep
going back in and changing it. Then, everytime I design something on that
page, it changes it again.

Any suggestions? This is so frustrating!!

Which version of Access? It might be a bug. Make sure that Access and Office
are fully patched.

It could be Name Autocorrect going goofy. In Access 2003 and earlier go to
Tools, Options, General tab. Turn off the Name AutoCorrect options. While
there turn off Compact of Close. Trust me.

Next go to the Spelling tab and click on the AutoCorrect Options. Believe it
or not, this AutoCorrect is different thatn Name AutoCorrect. See if for some
strange reason "frmflowers" is listed in the scroll down area.

However I got a feeling that your database might be corrupted. If the above
doesn't work, create a new database file and import everything from the old
database. See if the new on works.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"jimati" wrote:

I have a list box on a form that has information that changes based off of a
field on my form.

For example, in a text box if I put "RED", the list box shows me all flowers
that are red. If I put "Yellow", the list box updates and shows me all that
are yellow.

In the query, for flower type, I have the criteria look like this...

=Forms!frmflowers!txtcolor

At the discretion of Access, everytime I jump out of design view and try to
view the page, it changes the criteria to:

=Forms!frm1!txtcolor

I don't know where frm1 is or why it keeps changing, but I have to keep
going back in and changing it. Then, everytime I design something on that
page, it changes it again.

Any suggestions? This is so frustrating!!