Trouble changing a RECORD SOURCE on a form need help

[IamKJVonly]

I built a books data base table. One of the fields in that table is a DATE field and another field is LOCATION.


Then I built a query based on the DATE field being sorted. It works fine.
Next I built a Form based on that the DATE query so I can edit a record. It works fine.

Then I built a query based on the LOCATION field of where the book is located. It works fine.

Next I made a copy of my

Form based on the DATE query. I renamed the new Form LOCATION and went into the properties option and selected the LOCATION query for the record source. It appeared to take the change and rechecking the record source it show the LOCATION query.

However when ever I run the LOCATION form it gives me the DATE query data instead of the LOCATION query data. It acts as if it is still linked to the DATE query.

I've tried everything I can think of. Is there another step I should have done??

Any help will be greatly appreciated.
Dave
PS I'm just starting out in access 2010 and this is my first post in this form and if I'm not doing it right please let me know.
Thanks again for any help you can give me.

[orange]

Date is a reserved word in Access ---either change it to something meaningful to you (eg PublishedDate or ReviewedDate...) or enclose it in [Date] to show Access this is your terminology.

You could post a coy of your database so readers can see what you are working with.

Good luck.

[davegri]

Try a Compact and Repair. That's a lot of changes that the Name Autocorrect option has to deal with.

[IamKJVonly]

I'm sorry but the field I called "Date" is really "DateLastRead" so that is NOT the problem.
I've been trying everything I can think of to make it work But I can't seem to do it.
I really don't want to have to build a form scratch every time I want to do a different type of query.

Question am I doing the right procedure ?
Dave

[IamKJVonly]

I found the problem !!!
The problem was that in my query I had my LOCATION column first and my DateLastRead second followed by the other fields (Both were marked ascending) and the query worked

Here is where I got in trouble. My form listed the DateLastRead first and the LOCATION field second. As soon as I marked the DateLastReadfield NOT sorted the form worked right. In the form that was linked to a query I though the query would override the form but the form overrides the query. confusing??


Dave