Form Blinks when data is updated

G

Guest

I have Parent form with 5 subforms. When I do an update of data the forms
blink and it annoys me. Ive tried requery, refresh, repaint in severl
different location in my code and nothing works. Is there a better way to
refresh your form data that I dont know about?

Basic update Example

set db = currentdb()
set rec = db.openrecordset("Table")
with rec
.edit
.Rec!Field = 1
.update
end with
rec.close
db.close
me.requery
 
A

Allen Browne

The Requery at the end of your code causes the form to reload. As the form
reloads and moves to the first record, you will perceive this as "blinking."

You would turn Echo off (to suppress screen redraws.) However, you will have
to turn it on again at some point, and at that point it will blink as it
redraws.

The solution may therefore be to edit or add the record to the
RecordsetClone of the form instead of directly to the table. Then you don't
need the Requery, and you don't have the blinking problem.

Like this:

With Me.RecordsetClone:
.Edit
!Field1 = 1
.Update
End With
 

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

Top