Query Parameters Changes

  • Thread starter Thread starter Dan B
  • Start date Start date
D

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.
 
Dan B said:
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.
Click to expand...

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.
 
Back
Top