Quote:I believe the reason for the errors is because you have fields in your main database named the same thing as fields in your subform's database. Am I correct that Note, Amount, Category, and Name appear on both forms?
Yes! You are correct. The errors went away after changing the field names for the subform.
But now the question is why didn't that cause a problem when using regular retrieve specs, as opposed to the programmed specs?
Quote:How many records do you have in the parent database?
How many records in the child database?
Relational or natural linking?
541
684
Natural
Quote:...and can not get Sesame to freeze.
Sesame did not freeze. The
Search/Update view (or tab) froze. I could still use the Application tab or my custom main menu tab. Only the view of the Search/Update tab for the form I was performing the search in, would be frozen. I could still click on the "Record Navigation Toolbar" to navigate through the result set, but the form view did not show anything but the search screen with the retrieve specs. The "Search/Update Menu" tree showed, but would not accept any mouse clicks. If I minimized Sesame and then restored it's window, the area where I should see the form just showed the portion of my desktop that was in that area while Sesame was minimized. If I clicked on the Application tab so that the splash screen showed, then clicked back on the Search/Update tab, I would still see the splash screen. Likewise, if I clicked on the tab for my custom main menu, then back on the Search/Update tab, I would still be looking at a view of my custom main menu.
Maybe I should have said that the tab did not update it's view vs. saying that it froze.