Query Parameters Changes

[Dan B]

I have a reoccurring problem. With new forms when I use
a form parameter in a query for a drop down box it
sometimes changes the form name on reopening. Once it
starts to happen I have had to just can the form and
start over. I think it might have something to do with
converting macros to VB on the forms whose names start
popping up in the parameters in my new forms. I've
renamed the forms that appear and it will reset to
another form.

Any help would be appreciated.

 

[Dirk Goldgar]

I have a reoccurring problem. With new forms when I use
a form parameter in a query for a drop down box it
sometimes changes the form name on reopening. Once it
starts to happen I have had to just can the form and
start over. I think it might have something to do with
converting macros to VB on the forms whose names start
popping up in the parameters in my new forms. I've
renamed the forms that appear and it will reset to
another form.

Any help would be appreciated.

I don't know, but if you're using Access 2000 or later it may be the
action of the Name Autocorrect "misfeature". Go into Tools ->
Options -> General tab, turn off Name Autocorrect, and see if the
problem goes away.