WEIRD ERROR While updating an Access form recordset (prompts for old field)
I have updated the name of a field in the table from which a form and its subform draw information. The recordsource property is empty at design, but is filled in through code. The thing is, there is one field on the table whose name I changed. I updated ALL the objects/forms/components to the new field name, and STILL, when it runs the code line where it feeds the recordsource property of the form, I get an inputbox asking me for the value of the old field that is no longer ANYWHERE in the form. Besides, the query I assign to the form is valid (verified), and it sure does not include that old field name. And the funny thing is, it does not happen every time; just about 80% of the times. It seems as if there is some kind of residue in a cache file or something... I don't understand. Also, I am running that database from a network.
I AM SO SICK OF ACCESS BUGS.... Version 14, and you'd think they would have taken care of this basic stuff....
Anyone has an idea? Thanks so much.
I AM SO SICK OF ACCESS BUGS.... Version 14, and you'd think they would have taken care of this basic stuff....
Anyone has an idea? Thanks so much.
Open the query that you use for the recordsource.
Right click the window in the query builder and select 'properties'
Are there any occurrences of this field in the property sheet - such as in the filter or order by properties?
Also try making a backup and compact/repairing.
Right click the window in the query builder and select 'properties'
Are there any occurrences of this field in the property sheet - such as in the filter or order by properties?
Also try making a backup and compact/repairing.
ASKER
No, there are no references to the old field AT ALL.
In design mode, the property is left empty.
I have already tried compacting/repairing.
In design mode, the property is left empty.
I have already tried compacting/repairing.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
<I get an inputbox asking me for the value of the old field that is no longer ANYWHERE in the form.>
<No, there are no references to the old field AT ALL.>
It may be there somewhere, you may just not be able to locate it...
;-)
Sometimes references to the old field are lurking in comboboxes, or in your code.
How about just posting a example db that has this issue?
This way we are not just guessing at the solution...
JeffCoachman
<No, there are no references to the old field AT ALL.>
It may be there somewhere, you may just not be able to locate it...
;-)
Sometimes references to the old field are lurking in comboboxes, or in your code.
How about just posting a example db that has this issue?
This way we are not just guessing at the solution...
JeffCoachman
ASKER
That Rick Fishers "Find & Replace" is a tool that Microsoft should have included in Access a looooong time ago!! AWESOME!! <br /><br />Thanks, Dale! :)
Glad I could help.
F&R is a great program. I use it all the time, especially when I decide I want to change a field, table, or query name.
F&R is a great program. I use it all the time, especially when I decide I want to change a field, table, or query name.
ASKER