Query Headers Disappearing

Jhstephenson

I have a weird thing happening when I select a record on a query, display a form, and then return to the query. My header information disappears.

Here is what I see...

Call up the query...
Open the form by clicking on a record...
Close the form and return to the query...

It probably isn't visible in the images I attached, but the headers actually disappear as soon as the form opens.

Any ideas on what might be happening?

Thanks,
Jim

Jaymer

you have any Init/Render Scripts running on the Form?

Jhstephenson

Nope

AndySK

Hi
Apologies if you've tried this already but...

When you select your record to edit, are you opening in in the default pane? In your query, in the operations on records, your edit setting can be changed to open in a pop-up window. Give this a try to see if this makes a difference. Just a thought.

Cheers
Andy

Jhstephenson

The initial query was being called as a pop-up. When I changed it to default the issue went away. Which is nice, but it really doesn't explain why it was happening to being with. Even as a popup shouldn't the headings still be there?

Jhstephenson

Back to this issue.

I needed to change the way I opened the form from my query to use a process.

Now the called form opens as a popup, not matter what I tell it in the "Operations with records" for the operation that calls the process. I have told it to use the Default Output (result: opens as a popup), Popup (opens as a popup), New Tab (opens as a popup), Modeless Window (opens as a popup). In all cases the form opens as a popup when it is called from a process and when it does that the header row on the calling query disappears.

Any ideas?

Jaymer

it opens as a popup for 1 of 2 reasons:
1) using EDIT boname instead of VIEW boname
2) You are using VIEW, but its not the last statement in the Process - which means that process gets suspended and it has to be a popup to wait for input then close before the process can continue. If you need more statements to execute after the form is filled, then you attach a process to run after the Form is SAVEd

Jhstephenson

Thanks Jaymer,

Making it the last statement was the trick. Edit/View didn't seem to matter.

I had three operations in the process.

Set some session variables.
If logged In User is an employee VIEW PASS USING Main NOEDIT
IF logged In User is not an employee VIEW PASS USING Main

I changed 2 & 3 to be one operation as follows:

If LoggedInUser.AccessLevel='Employee' Then
VIEW PASS USING Main NOEDIT
ELSE VIEW PASS USING Main

Works like it should now.