I have a simple report layout for my CRM database that shows a sales rep's activities. The CRM has tables for contacts and related activities. The layout shows records from Activities, with a summary count field for each contact in a trailing sub-summary, so you can sort the layout by Contact and see just one line per contact. There is no Body part in the layout, just the sub-summary.

I control what the report displays using three global variable fields in the header: the sales rep's name (actually the ID underlies the name), the beginning date for the report and the ending date. Once you set those, then I have a "GO" button that runs a script that finds a set of activities matching the 3 criteria, then sorts the records so the sub-summaries show up properly.

Problem is, when I get a found set of more than one record, then go back to any of the global fields to change them, they're frozen. The rest of the header's OK, as I have other buttons there that work.

I can solve the problem easily by just clicking anywhere in the sub-summary section, then going back to the global fields, which are now active again. However, I don't want my sales reps that'll be using this report to have to remember that step --- the globals should always be available to change without having to click somewhere else on the layout.

I've tried to put steps in my GO script to fix this, like "GoTo Field", "GoTo Object", or "GoTo Record", but that doesn't work. Anyone have an idea for either 1) a script step that will replicate my clicking in the sub-summary or 2) some other way to solve the freeze problem? It seems like a bug in Filemaker, and I'm using FM 11.

Problem is, when I get a found set of more than one record, then go back to any of the global fields to change them, they're frozen.

Pop-ups freezing in header is a known bug which has been in existence far too long. To unfreeze them, you must be displaying the record being viewed. Only when it is 'in view' on the layout, will the pop-up release.

http://forums.filemaker.com/posts/812f3eb23b

Here is one link which discusses it.

Edited November 24, 201114 yr by LaRetta

Wow! I just read more about the issue on the Filemaker Forum (which I hadn't checked; I had always thought FMForums had more info). This is a serious bug that wasn't there in versions before FM10.

Thanks a lot for the link, LaRetta. Very helpful. I'll make sure I check all forums on problems in the future. There's always someone that's seen an issue before.

Most of us keep up on bugs and such, and many of us read all forums so if you post here, odds are we can point it out. Overall, this is the best forum of the bunch (and much easier to search) AND it has the best developers. And this forum also has me. :cool: