INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Form flashes when updated when using a recordsource query which has calculated fields

Form flashes when updated when using a recordsource query which has calculated fields

Form flashes when updated when using a recordsource query which has calculated fields

(OP)
I use a form which has a record-source as a query with calculated fields.

i.e. In the query, I have fields FirstName and Lastname and a calculated field FullName:[FirstName] & " " & [LastName].

If I update the first or second name on the form the form flashes very noticeably.

If I remove the calculated field from the query, then all is fine - is there any way round this, or is it simply an access bug?

Many thanks

Regards

Mark

RE: Form flashes when updated when using a recordsource query which has calculated fields

(OP)
I think the problem occurs when using a query with a calculated field in it, in a form which has a tab control on it.

There are a few threads on the web and all draw blanks so it would seem to be a bug with access itself.

Thanks Mark

RE: Form flashes when updated when using a recordsource query which has calculated fields

I suspect that your form is re-querying as you leave the edited field,
You are displaying concatenated fields (within the query - from the table), but also displaying each individual field - which are both editable.

Can't you leave out the concatenated field in the query, and simply set an unbound text box to:

CODE

=txtFirstname & " " & txtLastname 
?

I'm not sure why your form is requerying just because you edited a field (unless you are forcing a requery on leaving the field).
If you are forcing a requery - stop it - there is no need.

This way, the full name will display correctly as you leave the edited first or last name, and, there should be no requery 'flash'.

As an after-thought, why display Firstname, Lastname, and then Firstname + Lastname? Can't Firstname and Lastname be placed close so that the full name is obvious?

Def

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close