Text Field Control Source with equal signs

[WebDude]

Hi again

I have a continous form, whose record source is a query i created using the
query builder window. I noticed that, when scrolling up&down the continous
form (in formview), the textfields whose RecordSource has a "=" (equal sign)
in front of the expression will only refresh their data when the user stops
scrolling. Where as, when scrolling up&Down the same continous form (in
formview), the text fields whose control source is a field from the tables
recordsource refreshes immediately.

So, ive been creating calculated fields in the query grid instead of on the
form. So when the user scrolls down the continous form, he can easily browse
without having to stop and wait for the textfields to update.

Has anyone else noticed this?
Cheers,
Jeff

 

[John Vinson]

So, ive been creating calculated fields in the query grid instead of on the
form. So when the user scrolls down the continous form, he can easily browse
without having to stop and wait for the textfields to update.

Has anyone else noticed this?

Yes. Unbound (calculated) fields on a continuous form aren't really
"there" - it looks like you have many rows of controls, but you really
only have ONE row, displayed repeatedly.

Putting the expression in the query is the correct solution.

John W. Vinson[MVP]

 

[WebDude]

Putting the expression in the query is the correct solution.



Thanks John!

)