Update records 2

[xtraterrestrial]

When I make some changes to a record from a form the values don't seem to get updated immediately. I have to move to another record and move back before the new values show

Is there a command that lets me update the records instantly?

 

[jdegeorge]

As soon as you leave a field that record is updated. Are these fields calcuated fields or just fields from a table? If they're calculated, you might have to add a Me.Requery in that field's AfterUpdate property.

Jim DeGeorge

 

[RJFost]

Try a Requery; it reruns the underlying query (vs. closing & re-opening it). One caveat- after the Requery fires, you'll be positioned to the 1st record in the recordset (bookmarks don't help; they're destroyed by the requery)

 

[jdegeorge]

Me.Requery in the field's AfterUpdate property will not push you to the 1st record.

Jim DeGeorge

 

[RJFost]

I stand corrected. We've got a department grudge against AfterUpdate; it's bit us in the ass over & over again.

 

[xtraterrestrial]

Me.Requery seems to also reset all my public variables in the form

Can I do something like Me.Requery("FieldName&quot to just update the field or record

 

[jdegeorge]

Me.Requery isn't just for the one field. If the variable are public, they shouldn't be reset unless they're defined in the form and not in a module somehwere else.

Jim DeGeorge

 

[xtraterrestrial]

Yes I defined them in the form? Is there a way around this?

 

[jrollins]

I have two side-by-side workstations looking at the database on the network. When I change the selection in a combobox on the first workstation, the data doesn't update on the second workstation until I select a different record on the first workstation. Placing Me.Requery in the AfterUpdate event didn't work for me.

 

[xtraterrestrial]

I trid using Me.Refresh

that seemed to fix my problem

 

[jdegeorge]

rGlad to hear you got it working. You get a star for solving it yourself!

Jim DeGeorge

 

[jrollins]

I agree. It works! A star from me, too.