Text Field Control Source with equal signs


W

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
 
Ad

Advertisements

J

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]
 
Ad

Advertisements

W

WebDude

Putting the expression in the query is the correct solution.



Thanks John!

:))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top