Unexpected behavior of a dialog form when using VBA instead of a query (1 Viewer)

[MarioUY]

I'm developing an application where I built an stand-alone aggregate query (+ a subquery) that groups and totals certain information by years and use it as the record source for a Dialog continuos form. It works like a charm showing all the relevant years as designed, i.e., as a list in the form's detail section.

But, when the form is unbounded and a SQL string is used as the record source containing an EXACT copy of the one used in the query, instead of a list I'm getting surprisingly a single record, and must scroll down to be able to see the following records, one at a time. Please note that nothing else was changed in the properties whatsoever.

Any suggestions what is causing this behavior? (I'm using Office 365 Access - 64)

Thanks!

 

[Pat Hartman]

Do you mean that the form is opening in single record view?

 

[MarioUY]

No, is in continuos form but somehow the height of the detail section changed and shows only one record at a time.

 

[isladogs]

OK so why haven't you increased the height of the detail section?

 

[Pat Hartman]

So open the form in design view and fix the height of the detail section.

 

[MarioUY]

Thank you my friends, but this is not what I'm asking: I fixed it already w/o any problems. What I'd like to know is why, without any apparent reason, this is happening. Should I change something in the properties when I unbound the form, am I missing something here?

Thanks again!

 

[isladogs]

Suggest you upload a test database showing this behaviour. Remove any confidential data