Name Auto Correct - how to update query fields??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I turned off Name Auto Correct from tools>options> general tab due to the
problems it causes (bugs)
I have a main form ("A") with a continuous subform ("B"). On the detail
section of this subform is a button to open a new form ("C") to display
information related to the record.

On this new form ("C") is a continuous subform ("D") with a combo using a
query for its rowsource. I changed the query in this rowsource (corrected a
spelling mistake in a field name.) However, Access now asks for the
paramater value of this (now corrected non-existent) field name when calling
this form ("C") from the original subform.

I read that with name auto correct disabled, you have to update changes to
field names and queries manually. Having changed the query in the combo, how
else - and where else - can I do this? Is this why the main form ("A") is
still asking for the value of the non-existant field?

TIA
Rich
 
Rich,
I'm going to set aside the AutoCorrect issue and go for the more obvious
cause of a parameter request.

One critical question... do both queries against D and C run stand alone.
Test your SQL into the query design grid to see if they cause the prompt.

Also, check the code that may trigger upon opening Form C or D.

Then check any calculated fields in your query for a reference to the old
name, or check the Parameter Table itself.
I believe that if you had a mispelled name on the form, the only thing
that would indicate that is a #Name error... it wouldn't prompt for that
value. So, I'm thinking the prime suspect is the query.
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
 
Thanks Al.
As you suggest, the incorrectly named field was indeed in the query... it
just wasn't appearing to show up in the RecordSource for the combo, because I
had pasted it in from a forum post... so there were "invisible gaps" between
some of the elements in the SQL code that weren't evident until you cursor
thru the code (caused by pasting in where the user has pressed "enter" in the
original forum post??) The field showed up in query builder and I then found
it in the record source.
Life is so much easier without Name Auto Correct!!!!!
rich
 
Back
Top